2 person_id INTEGER PRIMARY KEY AUTO_INCREMENT,
3 name varchar(20) not null,
4 age integer default '18',
7 is_rock_star tinyint default '1',
9 UNIQUE KEY UC_person_id (person_id)
12 create unique index unique_name on person (name);
14 create table employee (
17 CONSTRAINT FK5302D47D93FE702E_diff FOREIGN KEY (employee_id) REFERENCES person (person_id),
18 PRIMARY KEY (employee_id, position)