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)