DB기말과제_임미숙
테이블 (5)
AUTHOR (Untitled4)
- authorID (Key) — char(20) — 기본 키 — NOT NULL
- ISBN (Key2) — int(10) — 외래 키 → BOOK.ISBN — NOT NULL
- name (Field) — char(20)
- description (Field2) — text
BOOK (Untitled)
- ISBN (Key) — int(10) — 기본 키 — NOT NULL
- title (Field) — char(20)
- author (Field2) — char(20)
- pubYear (Field3) — int(4)
- publisher (Field4) — char(10)
- remark (Field5) — char(5)
- bookstarNo (Key2) — int(10) — 외래 키 → BOOKSTAR.bookstarNo — NOT NULL
BOOKSTAR (Untitled2)
- bookstarNo (Key) — int(10) — 기본 키 — NOT NULL
- awardsTitle (Field) — char(5)
- readingRecord (Field2) — int(5)
CLASS (Untitled5)
- classCode (Key) — char(3) — 기본 키 — NOT NULL
- schoolYear (Field) — char(5)
- teachername (Field2) — char(5)
USER (Untitled3)
- userID (Key) — char(10) — 기본 키 — NOT NULL
- classCode (Key3) — char(3) — 외래 키 → CLASS.classCode — NOT NULL
- name (Field) — char(10)
- phone (Field2) — int(15)
- class (Field3) — char(5)
- readingRecord (Field4) — int(5)
- bookstarNo (Key2) — int(10) — 외래 키 → BOOKSTAR.bookstarNo — NOT NULL