2022기말과제_임미숙
테이블 (5)
AUTHOR (Untitled3)
- authorID (Key) — char(20) — 기본 키 — NOT NULL
- registrationNumber (Key2) — int(10) — 외래 키 → RECOMMENDBOOK.registrationNumber — NOT NULL
- dlsNo (Key22) — int — 외래 키 → RECOMMENDBOOK.dlsNo — NOT NULL
- name (Field) — char(20)
- email (Field2) — char(20)
- description (Field3) — text
BOOK-STAR (Untitled5)
- B.S.No. (Key) — int(10) — 기본 키 — NOT NULL
- title (Field) — char(5)
- record (Field2) — char(5)
- username (Field3) — char(10)
- userID (Key2) — char(10) — 외래 키 → USER.userID — NOT NULL
DLS (Untitled4)
- dlsNo (Key) — int — 기본 키 — NOT NULL
- restrationNo. (Field2) — int(10)
- rentDate (Field3) — int(10)
- returnDate (Field4) — int(10)
RECOMMENDBOOK (Untitled)
- registrationNumber (Key) — int(10) — 기본 키 — NOT NULL
- dlsNo (Key2) — int — 외래 키 → DLS.dlsNo — NOT NULL
- title (Field) — char(30)
- schoolYearDivision (Field2) — char(5)
- pubYear (Field3) — int(4)
- price (Field4) — char(10)
- registraionDate (Field5) — char(100
USER (Untitled2)
- userID (Key) — char(10) — 기본 키 — NOT NULL
- name (Field) — char(10)
- phone (Field2) — int915)
- class (Field3) — char(5)
- dlsNo (Key2) — int — 외래 키 → DLS.dlsNo — NOT NULL