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)