erd2

Tables (4)

movie (Untitled)

  • mov_no (Key) — int(11) — Primary key — NOT NULL
  • mov_name (Field) — varchar(45)
  • contents (Field2) — varchar(255)
  • director (Field3) — varchar(40)
  • actor (Field4) — varchar(255)

payment (Untitled4)

  • pay_no (Key) — int(11) — Primary key — NOT NULL
  • mov_no (Key2) — int(11) — Foreign key → movie.mov_no — NOT NULL
  • the_no (Key3) — int(11) — Foreign key → theater.the_no — NOT NULL
  • user_no (Key4) — int(11) — Foreign key → user.user_no — NOT NULL
  • Field

theater (Untitled3)

  • the_no (Key) — int(11) — Primary key — NOT NULL
  • the_address (Field) — varchar(55)
  • seating (Field2) — int(11)

user (Untitled2)

  • user_no (Key) — int(11) — Primary key — NOT NULL
  • user_id (Field) — varchar(40)
  • user_pw (Field2) — varchar(40)
  • user_name (Field3) — varchar(40)
  • phone (Field4) — varchar(40)
  • user_age (Field5) — int(11)