VIDEO STORE

Tables (8)

BIOGRAPHY (Untitled8)

    CASTING (Untitled5)

      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)

      PERSON (Untitled6)

        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)

        ROLE (Untitled7)

          VIDEO (Untitled2)

          • v_code (Key) — CHAR(6) — Primary key — NOT NULL
          • r_date (Field) — INT(8)
          • r_nt (Field2) — INT(10)