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