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',
8 physical_description text,
9 UNIQUE KEY UC_person_id (person_id),
10 UNIQUE KEY UC_age_name (age, name)
13 create unique index unique_name on person (name);
15 create table employee (
18 CONSTRAINT FK5302D47D93FE702E_diff FOREIGN KEY (employee_id) REFERENCES person (person_id),
19 CONSTRAINT `demo_constraint` CHECK (`employee_id` > 0 and `employee_id` IS NOT NULL and `employee_id` not in (0)),
20 PRIMARY KEY (employee_id, position)