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