123
Tables (6)
AUTHOR (Untitled3)
- proNo (Key) — int(12) — Primary key — NOT NULL
- name (Field) — char(8)
- address (Field2) — char(11)
- ID (Key2) — int(10) — Foreign key → PUBILISHING HOUSE.ID — NOT NULL
BOOK (Untitled)
- bookNo (Key) — int(10) — Primary key — NOT NULL
- name (Field) — char(8)
- pubDate (Field2) — int(8)
BOOK1 (Untitled4)
- bookNo (Key) — int(10) — Foreign key → BOOK.bookNo — NOT NULL
- proNo (Key2) — int(12) — Foreign key → AUTHOR.proNo — NOT NULL
- ID (Key3) — int(10) — Foreign key → PUBILISHING HOUSE.ID — NOT NULL
- name (Key32) — char(8) — Foreign key → KEYWORD.name — NOT NULL
CHARACTER (Untitled6)
- nameNo (Key) — char(8) — Primary key — NOT NULL
KEYWORD (Untitled5)
- name (Key3) — char(8) — Primary key — NOT NULL
- bookNo (Key) — int(10) — Foreign key → BOOK.bookNo — NOT NULL
- nameNo (Key2) — char(8) — Foreign key → CHARACTER.nameNo — NOT NULL
PUBILISHING HOUSE (Untitled2)
- ID (Key) — int(10) — Primary key — NOT NULL
- name (Field) — char(8)
- address (Field2) — char(11)