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