dvd

Tables (5)

DVD (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • title (Field) — varchar(20)
  • content (Field2) — varchar
  • created_at (Field3) — date
  • modified_at (Field4) — date

DVDEach (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • movie_id (Key2) — int — Foreign key → DVD.id — NOT NULL
  • created_at (Field) — date
  • modified_at (Field2) — date

Rent (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → User.id — NOT NULL
  • rent_date (Field) — date

RentEach (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • dvd_id (Key2) — int — Foreign key → DVDEach.id — NOT NULL
  • rent_id (Key3) — int — Foreign key → Rent.id — NOT NULL
  • process (Field) — boolean
  • latefee (Field3) — int
  • edate (Field2) — date
  • rentfee (Field4) — int
  • returndate (Field5) — date

User (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • phone (Field2) — varchar(30)
  • gender (Field4) — boolean
  • birthdate (Field3) — date
  • img (Field5) — varcahr(200)
  • created_at (Field6) — date
  • modified_at (Field7) — date