consert
Tables (3)
reservations (공연예매)
- userId (유저아이디) — INT — Foreign key → users.id — NOT NULL
- showId (공연아이디) — INT — Foreign key → shows.id — NOT NULL
shows (공연)
- id (아이디) — INT — Primary key — NOT NULL
- name (공연명) — STRING
- explain (공연소개) — STRING
- startTime (공연시작시간) — DATE
- endTime (공연종료시간) — DATE
- location (공연장소) — STRING
- seat (공연좌석수) — INT
- img_url (공연이미지URL) — STRING
- category (공연카테고리) — STRING
- price (공연예매가격)
users (사용자)
- id (아이디) — INT — Primary key — NOT NULL
- email (이메일) — STRING
- password (패스워드) — STRING
- point (유저머니포인트) — INT
- is_admin (어드민여부) — BOOLEAN
- Field