데이터베이스_기말_김은수
테이블 (4)
AUTHER (Untitled4)
- autherID (Key) — int(10) — 기본 키 — NOT NULL
- name (Field) — char(30)
- authernativeName (Field2) — char(50)
- majorWork (Field3) — char(30)
NOVEL_BOOK (Untitled2)
- novelISBN (Key) — int(13) — 기본 키 — NOT NULL
- title (Field) — char(50)
- originalTitle (Field2) — char(50)
- kdc_6th (Field3) — char(20)
- pubYear (Field4) — int(4)
- expression (Field5) — char(3)
- auther (Field6) — char(30)
- pubiisher (Field7) — char(50)
- price (Field8) — int(30)
- type (Field9) — char(10)
- workID (Key2) — int(30) — 외래 키 → WORK.workID — NOT NULL
WORK (Untitled)
- workID (Key) — int(30) — 기본 키 — NOT NULL
- workTitle (Field) — chat(30)
WORK_AUTHER (Untitled3)
- workID (Key) — int(30) — 외래 키 → WORK.workID — NOT NULL
- autherID (Key2) — int(10) — 외래 키 → AUTHER.autherID — NOT NULL