VIDEO STORE
Tables (8)
CUSTOMER (Untitled)
- c_no (Key) — INT(10) — Primary key — NOT NULL
- c_name (Field) — VARCHAR(20)
- c_add (Field2) — VARCHAR(100)
MOVIE (Untitled4)
- title (Key3) — VARCHAR(50) — Primary key — NOT NULL
- v_code (Key4) — CHAR(6) — Foreign key → VIDEO.v_code — NOT NULL
- p_year (Field2) — INT(4)
RENTAL-RECORD (Untitled3)
- r_no (Key4) — INT(10) — Primary key — NOT NULL
- c_no (Key2) — INT(10) — Foreign key → CUSTOMER.c_no — NOT NULL
- v_code (Key3) — CHAR(6) — Foreign key → VIDEO.v_code — NOT NULL
- r_date (Field) — INT(8)
- r_time (Field2) — VARCHAR(10)
VIDEO (Untitled2)
- v_code (Key) — CHAR(6) — Primary key — NOT NULL
- r_date (Field) — INT(8)
- r_nt (Field2) — INT(10)