gunwoo
Tables (19)
Album (Untitled14)
- albumid (Key) — NUMBER(2) — Primary key — NOT NULL
- title (Field) — CHAR(20)
- crdate (Field2) — DATETIME
Appear (Untitled16)
- songid (Key) — NUMBER(2) — Foreign key → Song.songid — NOT NULL
- albumid (Key2) — NUMBER(2) — Foreign key → Album.albumid — NOT NULL
Appeer (Untitled4)
- cid (Key2) — NUMBER(2) — Foreign key → Cource.cid — NOT NULL
- pid (Key) — NUMBER(2) — Foreign key → Professor.pid — NOT NULL
Child (Untitled10)
- name (Field) — CHAR(20)
- age (Field2) — CHAR(3)
- ssn (Key) — NUMBER(2) — Foreign key → Depend.ssn — NOT NULL
Cource (Untitled3)
- cid (Key) — NUMBER(2) — Primary key — NOT NULL
- cname (Field) — CHAR(20)
- room (Field2) — NUMBER(1)
- class (Field3) — NUMBER(1)
Depend (Untitled9)
- ssn (Key) — NUMBER(2) — Foreign key → Emp.ssn — NOT NULL
Dept (Untitled7)
- dno (Key) — NUMBER(2) — Primary key — NOT NULL
- dname (Field) — CHAR(20)
- budget (Field2) — CHAR(15)
Emp (Untitled6)
- ssn (Key) — NUMBER(2) — Primary key — NOT NULL
- salary (Field) — CHAR(15)
- phone (Field2) — CHAR(13)
Instrument (Untitled19)
- instrid (Key) — NUMBER(2) — Primary key — NOT NULL
- iname (Field) — CHAR(20)
- key (Field2) — CHAR(10)
- Field3
Manages (Untitled8)
- dno (Key2) — NUMBER(2) — Foreign key → Dept.dno — NOT NULL
- ssn (Key3) — NUMBER(2) — Foreign key → Emp.ssn — NOT NULL
Musicians (Untitled12)
- ssn (Key) — NUMBER(2) — Primary key — NOT NULL
- name (Field) — CHAR(20)
- address (Field2) — VARCHAR(100)
Perform (Untitled15)
- ssn (Key) — NUMBER(2) — Foreign key → Musicians.ssn — NOT NULL
- songid (Key2) — NUMBER(2) — Foreign key → Song.songid — NOT NULL
Play (Untitled18)
- ssn (Key) — NUMBER(2) — Foreign key → Musicians.ssn — NOT NULL
- instrid (Key2) — NUMBER(2) — Foreign key → Instrument.instrid — NOT NULL
Produce (Untitled13)
- albumid (Key2) — NUMBER(2) — Foreign key → Album.albumid — NOT NULL
- ssn (Key) — NUMBER(2) — Foreign key → Musicians.ssn — NOT NULL
Product (Untitled2)
- grade (Field) — NUMBER(1)
- sno (Key) — NUMBER(2) — Foreign key → Student.sno — NOT NULL
- cid (Key2) — NUMBER(2) — Foreign key → Cource.cid — NOT NULL
Professor (Untitled5)
- pid (Key) — NUMBER(2) — Primary key — NOT NULL
- pname (Field) — CHAR(20)
Song (Untitled17)
- songid (Key) — NUMBER(2) — Primary key — NOT NULL
- title (Field) — CHAR(20)
- author (Field2) — CHAR(10)
Student (Untitled)
- sno (Key) — NUMBER(2) — Primary key — NOT NULL
- sname (Field) — CHAR(20)
Works_in (Untitled11)
- ssn (Key) — NUMBER(2) — Foreign key → Emp.ssn — NOT NULL
- dno (Key2) — NUMBER(2) — Foreign key → Dept.dno — NOT NULL