CREATE INDEX collection_object_idx_object_c ON collection_object (object);
--
+-- Table: demographic
+--
+CREATE TABLE demographic (
+ demographicid INTEGER PRIMARY KEY NOT NULL,
+ name varchar(100) NOT NULL
+);
+
+CREATE UNIQUE INDEX demographic_name_demographic ON demographic (name);
+
+--
-- Table: employee
--
CREATE TABLE employee (
--
CREATE TABLE genre (
genreid INTEGER PRIMARY KEY NOT NULL,
- name varchar(100) NOT NULL
+ name varchar(100) NOT NULL,
+ demographicid INTEGER NOT NULL
);
CREATE UNIQUE INDEX genre_name_genre ON genre (name);