LIBRARY
Tables (8)
BOOK (Untitled9)
- 책ID (bookID) — VARCHAR2(6) — Primary key
- ISBN — VARCHAR2(4) — NOT NULL
- 관리상태 (state) — VARCHAR2(10)
- 상태 (avalability) — VARCHAR2(1)
- Field (debyCost) — NUMBER(10,2)
- Field (lostCost) — NUMBER(10,2)
- 주소 (address) — VARCHAR2(50) — Foreign key → LOCATION.주소 — NOT NULL
BRANCH (Untitled6)
- 구역이름 (branchname) — VARCHAR2(40) — Primary key — NOT NULL
- 번호 (phone) — NUMBER(9)
- 주소 (address) — VARCHAR2(50) — Foreign key → LOCATION.주소 — NOT NULL
CARD (Untitled2)
- 카드ID (cardID) — NUMBER — Primary key — NOT NULL
- 상태 (status) — VARCHAR2(1)
- 벌금 (fines) — NUMBER
CUSTOMER (Untitled4)
- 고객ID (customerID) — NUMBER — Primary key — NOT NULL
- 이름 (name) — VARCHAR2(40)
- 고객주소 (customerAddress) — VARCHAR2(50)
- 번호 (phone) — NUMBER(9)
- 비밀번호 (password) — VARCHAR2(20)
- 닉네임 (userName) — VARCHAR2(10)
- 가입날짜 (dateSignUp) — DATE
- 카드ID (cardID) — NUMBER — Foreign key → CARD.카드ID — NOT NULL
EMPLOYEE (Untitled5)
- 직원ID (employeeID) — NUMBER — Primary key — NOT NULL
- 이름 (name) — VARCHAR2(40)
- 직원주소 (employeeAddress) — VARCHAR2(50)
- 번호 (phone) — NUMBER(9)
- 비밀번호 (password) — VARCHAR2(20)
- 닉네임 (userName) — VARCHAR2(10)
- 봉급 (paycheck) — NUMBER
- 구역이름 (branchname) — VARCHAR2(40) — Foreign key → BRANCH.구역이름 — NOT NULL
- 카드ID (cardID) — NUMBER — Foreign key → CARD.카드ID — NOT NULL
LOCATION (Untitled7)
- 주소 (address) — VARCHAR2(50) — Primary key — NOT NULL
RENT (Untitled8)
- 책ID (bookID) — VARCHAR2(6) — Foreign key → BOOK.책ID
- 카드ID (cardID) — NUMBER — Foreign key → CARD.카드ID — NOT NULL
- 빌린날짜 (apporpriationDate) — DATE
- 반환날짜 (returnDate) — DATE
VIDEO (Untitled)
- 제목 (title) — VARCHAR2(50) — Primary key — NOT NULL
- 년도 (year) — INT — Primary key
- 비디오ID (videoID) — VARCHAR2(6) — Primary key
- 상태 (state) — VARCHAR2(10)
- 관리상태 (avalability) — VARCHAR2(1)
- Field (debyCost) — NUMBER(10,2)
- Field (lostCost) — NUMBER(10,2)