이거다

테이블 (13)

admin

  • admin_id — int — 기본 키 — NOT NULL
  • email — varchar2(255)
  • password — varchar2(255)

calendar

  • calendar_id — int — 기본 키 — NOT NULL
  • selected_at — timestamp
  • type — varchar2(50) — type : reserve / select
  • content_id — int — 외래 키 → content.content_id — NOT NULL
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • reservation_id — int — 외래 키 → reservation.reservation_id — NOT NULL — 누가 언제 얼만큼 예매했는지 확인

content

  • content_id — int — 기본 키 — NOT NULL
  • content_kind — varchar2(255)
  • category — varchar2(100)
  • location — varchar2(255)
  • title — varchar2(255)
  • description — text
  • reservation_type — varchar2(50)
  • start_at — timestamp
  • end_at — timestamp
  • adult_price — int
  • teen_price — int
  • child_price — int
  • main_image_path — varchar2(255)
  • detail_description — varchar2(255)
  • is_active — boolean
  • is_delete — boolean
  • content_time — varchar2(255)
  • instagram_url — varchar2(255)
  • x_url — varchar2(255)
  • status — varchar2(255)
  • user_id — int — 외래 키 → user.user_id — NOT NULL

content_like

  • content_like_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • content_id — int — 외래 키 → content.content_id — NOT NULL

content_reply

  • creply_id — 기본 키 — NOT NULL
  • content_id — int — 외래 키 → content.content_id — NOT NULL
  • title
  • body
  • writer
  • user_id — NOT NULL
  • created_at
  • ono
  • gno

content_schedule

  • schedule_id — int — 기본 키 — NOT NULL — content에 종속된 예약 일정
  • scheduled_at — varchar2(50)
  • time_zone — varchar2(50)
  • total_ticket — int
  • current_ticket — int
  • content_id — int — 외래 키 → content.content_id — NOT NULL

payment

  • payment_id — int — 기본 키 — NOT NULL
  • payment_method — varchar2(50) — 무통장/카드/간편결제 등
  • payment_status — varchar2(50) — 결제완료/결제실패 등
  • amount_price — int
  • paid_at — timestamp
  • reservation_id — int — 외래 키 → reservation.reservation_id — NOT NULL
  • refund_status — varchar2(50)
  • payment_key — vachar2(255)
  • order_key — varchar2(255)
  • cancel_amount (환불해준금액) — int

reply

  • reply_id — int — 기본 키 — NOT NULL
  • title — varchar2(255)
  • body — text
  • reply_status — int
  • created_at — timestamp
  • gno — int
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • admin_id — int — 외래 키 → admin.admin_id — NOT NULL

reservation

  • reservation_id — int — 기본 키 — 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
  • teen_qty (student_qty) — int
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • content_id — int — 외래 키 → content.content_id — NOT NULL
  • reservation_type — varchar2(50)
  • receiver_name — varchar2(10)
  • receiver_birth — timestamp
  • receiver_phone — varchar2(50)
  • reserve_visit — boolean
  • receive_type — varchar2(255)
  • admin_id — int — 외래 키 → admin.admin_id — NOT NULL
  • 시간대 (time_zone) — varchar2(50)

review

  • review_id — int — 기본 키 — NOT NULL
  • content — text
  • rating — int
  • image_org — varchar2(255)
  • image_new — varchar2(255)
  • visited_at — varchar2(255)
  • created_at — timestamp — 작성일
  • content_id — int — 외래 키 → content.content_id — NOT NULL
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • reservation_id — int — 외래 키 → reservation.reservation_id — NOT NULL — 누가 언제 얼만큼 예매했는지 확인

tag

  • tag_id — int — 기본 키 — NOT NULL
  • tag_name — varchar2(100)
  • category — varchar2(100)

user

  • user_id — int — 기본 키 — NOT NULL
  • email — varchar2(255)
  • password — varchar2(255)
  • login_type — char
  • name — varchar2(100)
  • gender — char
  • birthday — varchar2(20)
  • registered_at — timestamp
  • phone_number — varchar(50)
  • role — int

user_tag

  • user_tag_id — int — 기본 키 — NOT NULL
  • tag_id — int — 외래 키 → tag.tag_id — NOT NULL
  • user_id — int — 외래 키 → user.user_id — NOT NULL