ㄷㅇㅈ

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