이거다
테이블 (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