DB기말과제_임미숙
테이블 (5)
AUTHOR (Untitled2)
- authorId (Key) — char(20) — 기본 키 — NOT NULL
- name (Field) — char(20)
- e-mail (Field2) — char(20)
- description (Field3) — text
BOOK (Untitled)
- bookNo (Key) — char(10) — 기본 키 — NOT NULL
- authorId (Key3) — char(20) — 외래 키 → AUTHOR.authorId — NOT NULL
- booktitle (Field) — char(20)
- author (Field2) — char(20)
- pubYear (Field3) — int(4)
- publisher (Field4) — char(10)
- recommend (Field5) — char(3)
- readingrecordID (Key2) — char(5) — 외래 키 → READINGRECORD.readingrecordID — NOT NULL
BOOKSTAR (Untitled6)
- bookstarNo (Key) — char(10) — 기본 키 — NOT NULL
- awardsTitle (Field) — char(5)
- username (Field2) — char(5)
READINGRECORD (Untitled4)
- readingrecordID (Key) — char(5) — 기본 키 — NOT NULL
- recordQty (Field) — int(5)
USER (Untitled5)
- userID (Key) — char(10) — 기본 키 — NOT NULL
- bookstarNo (Key3) — char(10) — 외래 키 → BOOKSTAR.bookstarNo — NOT NULL
- username (Field) — char(5)
- phone (Field2) — int(15)
- awardsTitle (Field3) — char(5)
- recordQty (Field4) — int(5)
- readingrecordID (Key2) — char(5) — 외래 키 → READINGRECORD.readingrecordID — NOT NULL