tiple

Tables (5)

concert (콘서트)

  • id (콘서트_고유아이디) — not null — Primary key — NOT NULL
  • name (콘서트_이름) — not null
  • artist_name (아티스트이름) — not null
  • start_time (시작일) — not null
  • end_time (종료일) — not null
  • reservation_start_time (예매시작일) — not null
  • reservation_end_time (예매 종료일) — not null
  • remaining_seat (남은 좌석) — not null
  • status (콘서트_상태) — not null
  • concert_hall_name (콘서트홀_이름) — not null
  • concert_hall_address (콘서트홀_주소) — not null
  • concert_hall_seat_info (콘서트홀_전체좌석정보) — not null
  • created_at (생성일) — not null
  • updated_at (수정일)
  • deleted_at (삭제일)

concert_seat (콘서트_죄석)

  • id (좌석_고유아이디) — not null — Primary key — NOT NULL
  • conert_id (콘서트_고유아이디) — not null — Foreign key → concert.id — NOT NULL
  • grade (등급) — not null
  • seat_number (좌석번호) — not null
  • created_at (생성일) — not null
  • updated_at (수정일)
  • deleted_at (삭제일)

member (유저)

  • id (회원_고유아이디) — not null — Primary key — NOT NULL
  • email (이메일) — not null
  • password (비밀번호) — not null
  • name (이름) — not null
  • created_at (생성일) — not null
  • updated_at (수정일)
  • deleted_at (삭제일)

ticket_reservation (타켓_예매)

  • id (티켓_예약 고유아이디) — Primary key — NOT NULL
  • id (좌석_고유아이디) — not null — Foreign key → concert_seat.id — NOT NULL
  • id (회원_고유아이디) — not null — Foreign key → member.id — NOT NULL
  • status (티켓_예매 상태) — not null
  • created_at (Field2) — not null
  • updated_at (Field3)
  • deleted_at (Field4)

waiting (콘서트_대기순번)

  • id (Key) — not null — Primary key — NOT NULL
  • concert_id (콘서트_고유아이디) — not null — Foreign key → concert.id — NOT NULL
  • id (회원_고유아이디) — not null — Foreign key → member.id — NOT NULL
  • waiting_number (대기순번) — not null
  • status (상태) — not null
  • created_at (생성일) — not null
  • updated_at (수정일)
  • deleted_at (삭제일)