1

Tables (7)

admin

  • admin_id — TEXT
  • admin_pw — TEXT

benefit

  • defid — INT(11) — Primary key — NOT NULL
  • poster_path — TEXT
  • poster_name — VARCHAR(100)

event

  • defid — INT(11) — Primary key — NOT NULL
  • poster_path — TEXT
  • poster_name — TEXT

movie_info

  • movie_id — INT(11) — Primary key — NOT NULL
  • screen_number — INT(11)
  • title — TEXT — NOT NULL
  • description — TEXT
  • short_description — TEXT
  • poster — TEXT
  • runtime — INT(11)
  • reserv_count — INT(11)
  • start_time1 — TEXT
  • start_time2 — TEXT
  • start_time3 — TEXT
  • start_time4 — TEXT
  • start_time5 — TEXT
  • start_time6 — TEXT
  • start_time7 — TEXT
  • start_time8 — TEXT
  • start_time9 — TEXT

seat

  • seat_id — INT(11) — Primary key — NOT NULL
  • user_defid — INT(11) — Foreign key → user.defid — NOT NULL
  • movie_id — INT(11) — Foreign key → movie_info.movie_id — NOT NULL
  • screen_num — INT(11) — NOT NULL
  • seat_num — TEXT — NOT NULL
  • user_id — VARCHAR(50)
  • date — TEXT
  • time — TEXT
  • movie_name — TEXT
  • userName — TEXT
  • pickcount — INT(11)
  • card_num — VARCHAR(50)
  • card_bank — VARCHAR(50)
  • card_date — VARCHAR(50)

user

  • defid — INT(11) — Primary key — NOT NULL
  • id — VARCHAR(50) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • pw — VARCHAR(50) — NOT NULL
  • profile — VARCHAR(50)
  • point — INT(11)

user_card

  • card_defid — INT(11) — Primary key — NOT NULL
  • defid (defid2) — INT(11) — Foreign key → user.defid — NOT NULL
  • user_id — VARCHAR(50)
  • card_num — VARCHAR(50)
  • card_date — VARCHAR(50)
  • card_bank — VARCHAR(50)
  • card_name — VARCHAR(100)