test
Tables (13)
calendar_entry
- calendar_id — int — Primary key — NOT NULL
- selected_at — timestamp
- content_id — int — Foreign key → content.content_id — NOT NULL
- user_id — int — Foreign key → user_account.user_id — NOT NULL
- entry_type — varchar2(50)
chat_message
- chat_id — varchar2(255) — Primary key — NOT NULL
- user_id — int — Foreign key → user_account.user_id — NOT NULL
- content_id — int — Foreign key → content.content_id — NOT NULL
- created_at — timestamp
content
- content_id — int — Primary key — NOT NULL
- category — varchar2(100)
- location — varchar2(255)
- title — varchar2(255)
- description — text
- reservation_type — varchar2(50)
- start_at — timestamp
- end_at — timestamp
- is_active — boolean
- adult_price — int
- teen_price — int
- child_price — int
- main_image_path — varchar2(255)
- detail_image_path — varchar2(255)
- memo — varchar2(255)
content_like
- content_like_id — varchar2(255) — Primary key — NOT NULL
- user_id — int — Foreign key → user_account.user_id — NOT NULL
- content_id — int — Foreign key → content.content_id — NOT NULL
content_schedule
- schedule_id — int — Primary key — NOT NULL — content에 종속된 예약 일정
- scheduled_at — timestamp
- time_zone — varchar2(50)
- total_capacity — int
- current_count — int
- content_id — int — Foreign key → content.content_id — NOT NULL
payment
- payment_id — int — Primary key — NOT NULL
- payment_method — varchar2(50) — 무통장/카드/간편결제 등
- payment_status — varchar2(50) — 결제완료/결제실패 등
- amount_paid — int
- paid_at — timestamp
- reservation_id — int — Foreign key → reservation.reservation_id — NOT NULL
- memo — varchar2(255)
reply
- reply_id — int — Primary key — NOT NULL
- title — varchar2(255)
- body — text
- reply_status — varchar2(50)
- created_at — timestamp
- group_no — int
- order_no — int
- depth — int
- user_id — int — Foreign key → user_account.user_id — NOT NULL
reservation
- reservation_id — int — Primary key — NOT NULL — 누가 언제 얼만큼 예매했는지 확인
- reservation_code — varchar2(100)
- reserved_for_at — timestamp
- reservation_status — varchar2(50) — 예약완료/실패/수정 등
- total_price — int
- created_at — timestamp
- adult_qty — int
- child_qty — int
- student_qty — int
- user_id — int — Foreign key → user_account.user_id — NOT NULL
- schedule_id — int — Foreign key → content_schedule.schedule_id — NOT NULL
- content_id — int — Foreign key → content.content_id — NOT NULL
- reservation_type — varchar2(50)
review
- review_id — int — Primary key — NOT NULL
- body — text
- rating — int
- image_original_path — varchar2(255)
- visited_at — timestamp
- created_at — timestamp
- content_id — int — Foreign key → content.content_id — NOT NULL
- user_id — int — Foreign key → user_account.user_id — NOT NULL
- image_path — varchar2(255)
tag
- tag_id — int — Primary key — NOT NULL
- tag_name — varchar2(100)
ticket
- ticket_id — int — Primary key — NOT NULL
- ticket_code — varchar2(100)
- qr_key — varchar2(255) — 티켓을 식별하는 유일 키
- created_at — timestamp
- used_at — timestamp
user_account
- user_id — int — Primary key — NOT NULL
- email — varchar2(255)
- password — varchar2(255)
- login_type — char
- name — varchar2(100)
- gender — char
- birthday — varchar2(20)
- role — char
- registered_at — timestamp
user_tag
- user_tag_id — int — Primary key — NOT NULL
- tag_id — int — Foreign key → tag.tag_id — NOT NULL
- user_id — int — Foreign key → user_account.user_id — NOT NULL