show

Tables (4)

member (회원)

  • mem_id (회원아이디) — VARCHAR(30) — Primary key — NOT NULL
  • email (이메일) — VARCHAR(50)
  • password (비밀번호) — VARCHAR(50)
  • name (이름) — VARCHAR(50)

orderlist (주문내역)

  • order_id (예매번호) — VARCHAR(30) — Primary key — NOT NULL
  • order_date (예매일자) — DATE
  • order_qty (예매수량) — INT
  • tot_price (총예매가격) — INT
  • mem_id (회원아이디) — VARCHAR(30) — Foreign key → member.mem_id — NOT NULL
  • show_id (공연아이디) — VARCHAR(30) — Foreign key → showlist.show_id — NOT NULL
  • poster_id (포스터아이디) — VARCHAR(30) — Foreign key → showlist.poster_id — NOT NULL

poster (포스터)

  • poster_id (포스터아이디) — VARCHAR(30) — Primary key — NOT NULL
  • path (포스터경로) — VARCHAR(50)

showlist (공연)

  • show_id (공연아이디) — VARCHAR(30) — Primary key — NOT NULL
  • poster_id (포스터아이디) — VARCHAR(30) — Foreign key → poster.poster_id — NOT NULL
  • show_name (공연명) — VARCHAR(100)
  • show_date (공연날짜) — DATE
  • price (공연가격) — INT
  • description (공연소개) — LONGTEXT