연습4번
테이블 (5)
Client (Untitled)
- id (Key) — CHAR(30) — 기본 키 — NOT NULL
- name (Field) — CHAR(30)
- address (Field2) — CHAR(30)
- rental date (Field3) — date
- arrears (Field4) — CHAR(30)
- rental video (Field5) — CHAR(30)
Rental video (Untitled4)
- video id (Key2) — CHAR(30) — 외래 키 → Video.id — NOT NULL
- client id (Key) — CHAR(30) — 외래 키 → Client.id — NOT NULL
- fee (Field) — number
- day (Field2) — date
- arrears (Field3) — CHAR(30)
Video (Untitled2)
- id (Key) — CHAR(30) — 기본 키 — NOT NULL
- buying date (Field) — date
- rental count (Field2) — number
- title (Field3) — CHAR(30)
- years (Field4) — number
- fee (Field5) — CHAR(30)
- actor id (Key2) — CHAR(30) — 외래 키 → actor information.id — NOT NULL
- director id (Key3) — CHAR(30) — 외래 키 → director information.id — NOT NULL
- copy number (Field6) — number
actor information (Untitled3)
- id (Key) — CHAR(30) — 기본 키 — NOT NULL
- biography (Field) — CHAR(30)
director information (Untitled5)
- id (Key) — CHAR(30) — 기본 키 — NOT NULL
- biography (Field) — CHAR(30)