DVD_Store

Tables (3)

DVD (Untitled2)

  • serialNumber (영화번호) — NUMBER — Primary key — NOT NULL
  • movieName (영화이름) — VARCHAR2(30)
  • nation (출시국가) — VARCHAR2(30)
  • pubYear (개봉일) — DATE
  • charge (대여가격) — NUMBER
  • rental (현재대여여부) — CHAR(1)

Order (Untitled3)

  • orderId (주문번호) — NUMBER — Primary key — NOT NULL
  • orderDate (대여날짜) — DATE
  • returnDate (반납예정일) — DATE
  • overdueDay (연체일) — NUMBER
  • overdueCharge (연체금액) — NJUMBER
  • userNumber (유저번호) — NUMBER — Foreign key → User.userNumber — NOT NULL
  • serialNumber (영화번호) — NUMBER — Foreign key → DVD.serialNumber — NOT NULL

User (Untitled)

  • userNumber (유저번호) — NUMBER — Primary key — NOT NULL
  • userName (이름) — VARCHAR2(30)
  • phoneNumber (전화번호) — NUMBER
  • grade (유저등급) — VARCHAR2(10)
  • totalPaying (총결제금액) — NUMBER