모닥불
테이블 (28)
booking
- id — long — 기본 키 — NOT NULL
- member_id — long — NOT NULL
- campground_id — long — NOT NULL
- campsite_id — long — NOT NULL
- price — int
- check_in_date — date
- check_out_date — date
- booking_status — int
- id (id2) — long — 외래 키 → campsite.id — NOT NULL
- id (id3) — long — 외래 키 → campground.id — NOT NULL
- id (id4) — long — 외래 키 → member.id — NOT NULL
campground
- id — long — 기본 키 — NOT NULL
- location_detail_id — int — NOT NULL
- host_id — long — NOT NULL
- campground_name — VARCHAR(255) — NOT NULL
- postcode — VARCHAR(255)
- address — VARCHAR(255)
- detail_address — VARCHAR(255)
- extra_address — VARCHAR(255)
- approve — int
- phone — VARCHAR(255)
- member_id — long — 외래 키 → host.member_id — NOT NULL
- id (id2) — int — 외래 키 → location_detail.id — NOT NULL
campground_image
- id — long — 기본 키 — NOT NULL
- campground_id — long — NOT NULL
- file_name — VARCHAR(255)
- save_file_name — VARCHAR(255)
- iamge_path — VARCHAR(255)
- image_order — int
- id (id2) — long — 외래 키 → campground.id — NOT NULL
campground_option
- id — int — 기본 키 — NOT NULL
- option_name — VARCHAR(255)
campground_option_link
- id — long — 기본 키 — NOT NULL
- campground_suboption_id — int — NOT NULL
- campground_id — long — NOT NULL
- is_exist — bool
- id (id2) — long — 외래 키 → campground.id — NOT NULL
- id (id3) — int — 외래 키 → campground_suboption.id — NOT NULL
campground_suboption
- id — int — 기본 키 — NOT NULL
- campground_option_id — int — NOT NULL
- option_name — varchar(255)
- id (id2) — int — 외래 키 → campground_option.id — NOT NULL
campsite
- id — long — 기본 키 — NOT NULL
- campground_id — long — NOT NULL
- campsite_name — VARCHAR(255)
- campsite_description — VARCHAR(255)
- head_count — VARCHAR(255)
- weekday_price — int
- weekend_price — int
- campsite_number — int
- id (id2) — long — 외래 키 → campground.id — NOT NULL
campsite_image
- id — long — 기본 키 — NOT NULL
- campsite_id — VARCHAR(255) — NOT NULL
- file_name — VARCHAR(255)
- save_file_name — VARCHAR(255)
- iamge_path — VARCHAR(255)
- image_order — VARCHAR(255)
- id (id2) — long — 외래 키 → campsite.id — NOT NULL
campsite_option
- id — int — 기본 키 — NOT NULL
- option_name — VARCHAR(255)
campsite_option_link
- id — long — 기본 키 — NOT NULL
- campsite_id — long — NOT NULL
- campsite_suboption_id — int — NOT NULL
- is_exist — bool
- id (id2) — long — 외래 키 → campsite.id — NOT NULL
- id (id3) — int — 외래 키 → campsite_suboption.id — NOT NULL
campsite_price
- price_date — date — 기본 키 — NOT NULL
- campsite_id — long — 외래 키 → campsite.id — NOT NULL
- price — int
campsite_suboption
- id — int — 기본 키 — NOT NULL
- campsite_option_id — int — NOT NULL
- option_name — varchar(255)
- id (id2) — int — 외래 키 → campsite_option.id — NOT NULL
cancel_reason
- id — int — 기본 키 — NOT NULL
- reason — varchar(50)
chat_message
- id — long — 기본 키 — NOT NULL
- chat_room_id — long — NOT NULL
- member_id — long — NOT NULL
- message — varchar(500)
- read_status — bool
- created_at — timestamp
chat_room
- id — long — 기본 키 — NOT NULL
- created_at — timestamp
- campground_id — long — NOT NULL
- member_id — long — NOT NULL
- id (id2) — long — 외래 키 → campground.id — NOT NULL
coupon
- id — int — 기본 키 — NOT NULL
- coupon_name — varchar(50)
- coupon_code — varchar(50)
- discount_amount — int
- coupon_type — int
- is_active — bool
freeboard
- id — long — 기본 키 — NOT NULL
- member_id — long — NOT NULL
- title — varchar(100)
- content — varchar(1000)
- created_at — timestamp
- upated_at — timestamp
- id (id2) — long — 외래 키 → member.id — NOT NULL
freeboard_comment
- id — long — 기본 키 — NOT NULL
- parent_id — long — NOT NULL
- freeboard_id — long — NOT NULL
- member_id — long — NOT NULL
- content — varchar(255)
- created_at — timestamp
- id (id2) — long — 외래 키 → member.id — NOT NULL
- id (id3) — long — 외래 키 → freeboard.id — NOT NULL
freeboard_image
- id — long — 기본 키 — NOT NULL
- freeboard_id — long — NOT NULL
- file_name — VARCHAR(255)
- save_file_name — VARCHAR(255)
- iamge_path — VARCHAR(255)
- image_order — VARCHAR(255)
- id (id2) — long — 외래 키 → freeboard.id — NOT NULL
host
- member_id — long — 외래 키 → member.id — NOT NULL
- bank_name — VARCHAR(255)
- account — VARCHAR(255)
- account_holder — VARCHAR(255)
location
- id — int — 기본 키 — NOT NULL
- sido — VARCHAR(255)
location_detail
- id — int — 기본 키 — NOT NULL
- location_id — int — NOT NULL
- sigungu — VARCHAR(255)
- id (id2) — int — 외래 키 → location.id — NOT NULL
member
- id — long — 기본 키 — NOT NULL
- membership_id — long — NOT NULL
- user_id — VARCHAR(255)
- password — varchar(50)
- user_name — VARCHAR(255)
- phone — VARCHAR(255)
- mail — VARCHAR(255)
- role — varchar(255)
- created_at — timestamp
- updated_at — timestamp
- membership_start_date — date
- membership_end_date — date
- provider — varchar(10)
- id (id2) — int — 외래 키 → membership.id — NOT NULL
member_coupon
- id — int — 기본 키 — NOT NULL
- member_id — long — NOT NULL
- coupon_id — int — NOT NULL
- is_used — bool
- used_at — timestamp
- start_date — timestamp
- end_date — timestamp
- id (id2) — long — 외래 키 → member.id — NOT NULL
- id (id3) — int — 외래 키 → coupon.id — NOT NULL
membership
- id — int — 기본 키 — NOT NULL
- membership_name — varchar(255)
- discount_rate — int
payment
- id — long — 기본 키 — NOT NULL
- booking_id — long — NOT NULL
- member_id — long — NOT NULL
- member_coupon_id — long — NOT NULL
- order_number — long — unique
- amount — int
- payment_method — varchar(50)
- payment_status — int
- payment_date — timestamp
- approve_date — timestamp
- payment_tid — varchar(40)
- id (id2) — int — 외래 키 → member_coupon.id — NOT NULL
- id (id3) — long — 외래 키 → member.id — NOT NULL
- id (id4) — long — 외래 키 → booking.id — NOT NULL
payment_cancel
- id — long — 기본 키 — NOT NULL
- payment_id — long — 외래 키 → payment.id — NOT NULL
- cancel_reason_id — int — NOT NULL
- cancellation_fee — int
- refund_amount — int
- canceled_at — timestamp
- payment_tid — varchar(40)
- id (id2) — int — 외래 키 → cancel_reason.id — NOT NULL
review
- booking_id — long — 외래 키 → booking.id — NOT NULL
- member_id — long — NOT NULL
- message — VARCHAR(255)
- rating — int
- created_at — timestamp