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