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 (삭제일)