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