erd
Tables (18)
ACTOR (Untitled14)
- ACTOR_NAME (Key) — VARCHAR — Primary key — NOT NULL
- MOVIE_ID (영화 id) — VARCHAR — Foreign key → MOVIE.MOVIE_ID — NOT NULL
BUSINESS (Untitled10)
- BUSINESS_ID (Key) — VARCHAR — Primary key — NOT NULL
- BUSINESS_RANK (Field) — NUMBER
- BUSINESS_DUTY (Field2) — VARCHAR
CAFETERIA (Untitled12)
- MENU_ID (Key) — VARCHAR — Primary key — NOT NULL
- MENU_NAME (Field) — VARCHAR
- MENU_KIND (Field2) — VARCHAR
- PRICE (Field3) — NUMBER
CHOOSE (Untitled5)
- SCHEDULE_ID (Key) — VARCHAR — Foreign key → SCHEDULE.SCHEDULE_ID — NOT NULL
- MOVIE_ID (영화 id) — VARCHAR — Foreign key → MOVIE.MOVIE_ID — NOT NULL
- CUSTOMER_ID (Key2) — VARCHAR — Foreign key → CUSTOMER.CUSTOMER_ID — NOT NULL
CINEMA (CopyOfUntitled)
- CINEMA_ID (Key) — VARCHAR — Primary key — NOT NULL
- CINEMA_NAME (Field) — VARCHAR
- CINEMA_ADDR (Field2) — VARCHAR
CUSTOMER (Untitled6)
- CUSTOMER_ID (Key) — VARCHAR — Primary key — NOT NULL
- CUSTOMER_NAME (Field) — VARCHAR
- CUSTOMER_TEL (Field2) — VARCHAR
- IS_REGISTER (Field3) — VARCHAR
DISTRIBUTOR (CopyOfcontribution)
- DIST_ID (배급사 ID) — VARCHAR — Primary key — NOT NULL
- DIST_NAME (배급사 이름) — VARCHAR
- COUNTRY (국가) — VARCHAR
- ESTABLISHED (설립일) — DATE
DIST_MOV (Untitled)
- CONT_ID (배급사 ID) — VARCHAR — Foreign key → DISTRIBUTOR.DIST_ID — NOT NULL
- CINEMA_ID (Key) — VARCHAR — Foreign key → CINEMA.CINEMA_ID — NOT NULL
EMPLOYEE (Untitled9)
- EMPLOYEE_ID (Key) — VARCHAR — Primary key — NOT NULL
- EMPLOYEE_NAME (Field) — VARCHAR
- EMPLOYEE_TEL (Field2) — VARCHAR
- SALARY (Field3) — NUMBER
- BUSINESS_ID (Key2) — VARCHAR — Foreign key → BUSINESS.BUSINESS_ID — NOT NULL
FOOD_ORDER (Untitled13)
- MENU_ID (Key) — VARCHAR — Foreign key → CAFETERIA.MENU_ID — NOT NULL
- CUSTOMER_ID (Key2) — VARCHAR — Foreign key → CUSTOMER.CUSTOMER_ID — NOT NULL
MEMBERSHIP (Untitled11)
- MEMBER_ID (Key) — VARCHAR — Primary key — NOT NULL
- MEMBER_NAME (Field) — VARCHAR
- MEMBER_TEL (Field2) — VARCHAR
- EMAIL (Field3) — VARCHAR
- MILEAGE (Field4) — NUMBER
- MEMBER_TIER (Field5) — VARCHAR
- CUSTOMER_ID (Key2) — VARCHAR — Foreign key → CUSTOMER.CUSTOMER_ID — NOT NULL
MENUORD (Untitled7)
- ORDER_ID (Key) — VARCHAR — Primary key — NOT NULL
- PRICE (Field) — NUMBER
- PAYMENT (Field2) — VARCHAR
- PAYMENT_DATE (Field3) — DATE
- ORDER_COUNT (Field4) — NUMBER
- MENU_ID (Key2) — VARCHAR — Foreign key → CAFETERIA.MENU_ID — NOT NULL
- CUSTOMER_ID (Key3) — VARCHAR — Foreign key → CUSTOMER.CUSTOMER_ID — NOT NULL
MOVIE
- MOVIE_ID (영화 id) — VARCHAR — Primary key — NOT NULL
- TITLE (제목) — VARCHAR
- GENRE (장르) — VARCHAR
- GRADE (상영등급) — VARCHAR
- YEAR (제작년도) — DATE
- NATION (제작국가) — VARCHAR
- DIRECTOR (감독) — VARCHAR
- ACTOR (배우) — VARCHAR
- COMPANY (배급사) — VARCHAR
- OPENING (개봉상태) — VARCHAR
- SCREENING (상영상태) — VARCHAR
- STAR (평점) — VARCHAR
- DIST_ID (배급사 ID) — VARCHAR — Foreign key → DISTRIBUTOR.DIST_ID — NOT NULL
ORGANIZE (Untitled4)
- THEATER_ID (상영관 ID) — VARCHAR — Foreign key → THEATER.THEATER_ID — NOT NULL
- MOVIE_ID (영화 id) — VARCHAR — Foreign key → MOVIE.MOVIE_ID — NOT NULL
- SCHEDULE_ID (Key) — VARCHAR — Foreign key → SCHEDULE.SCHEDULE_ID — NOT NULL
SCHEDULE (Untitled3)
- SCHEDULE_ID (Key) — VARCHAR — Primary key — NOT NULL
- SCHEDULE_DATE (Field) — DATE
- SCHEDULE_TIME (Field2) — VARCHAR
- RUNTIME (Field3) — NUMBER
SEAT (Untitled2)
- SEAT_ID (Key) — VARCHAR — Primary key — NOT NULL
- IS_BOOKING (Field) — VARCHAR
- THEATER_ID (상영관 ID) — VARCHAR — Foreign key → THEATER.THEATER_ID — NOT NULL
THEATER (theater)
- THEATER_ID (상영관 ID) — VARCHAR — Primary key — NOT NULL
- THEATER_NAME (상영관 이름) — VARCHAR
- SEAT (Field) — NUMBER
- CINEMA_ID (Key) — VARCHAR — Foreign key → CINEMA.CINEMA_ID — NOT NULL
TICKET (Untitled8)
- TICKET_ID (Key) — VARCHAR — Primary key — NOT NULL
- PRICE (Field) — NUMBER
- PAYMENT (Field2) — VARCHAR
- BOOK_DATE (Field3) — DATE
- CUSTOMER_ID (Key2) — VARCHAR — Foreign key → CUSTOMER.CUSTOMER_ID — NOT NULL
- MOVIE_ID (영화 id) — VARCHAR — Foreign key → MOVIE.MOVIE_ID — NOT NULL
- SCHEDULE_ID (Key3) — VARCHAR — Foreign key → SCHEDULE.SCHEDULE_ID — NOT NULL
- THEATER_ID (상영관 ID) — VARCHAR — Foreign key → THEATER.THEATER_ID — NOT NULL
- SEAT_ID (Key4) — VARCHAR — Foreign key → SEAT.SEAT_ID — NOT NULL