허니문 리조트
테이블 (10)
estimate
- id — BIGSERIAL
- location — VARCHAR(20) — NOT NULL
- retrieval_start — TIMESTAMPTZ — NOT NULL
- retrieval_end — TIMESTAMPTZ — NOT NULL
- title — VARCHAR(1024) — NOT NULL
- request — TEXT — NOT NULL
- status — VARCHAR(10) — NOT NULL
- dir_name — VARCHAR(24) — NOT NULL
- processed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMPTZ
excel_file
- id — BIGSERIAL
- location_id — BIGINT — NOT NULL
- filename — VARCHAR(256) — NOT NULL
- file_path — VARCHAR(512) — NOT NULL
- parsed_at — TIMESTAMPTZ
- status — VARCHAR(10) — NOT NULL
- notes — VARCHAR(2048)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMPTZ
extra
- id — BIGSERIAL
- promotion_id — BIGINT — NOT NULL
- label — VARCHAR(1024) — NOT NULL
- value — VARCHAR(8192) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMPTZ
hotel
- id — BIGSERIAL
- excel_file_id — BIGINT — NOT NULL
- sheet_name — VARCHAR(256) — NOT NULL
- hotel_name — VARCHAR(256) — NOT NULL
- hotel_name_en — VARCHAR(256) — NOT NULL
- hotel_name_kr — VARCHAR(256) — NOT NULL
- phone — VARCHAR(32) — NOT NULL
- address — VARCHAR(512) — NOT NULL
- website — VARCHAR(512) — NOT NULL
- priority — INTEGER — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMPTZ
location
- id — BIGSERIAL
- name — VARCHAR(20) — NOT NULL
- banner_url — VARCHAR(512) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMPTZ
option
- id — BIGSERIAL
- promotion_id — BIGINT — NOT NULL
- option_category — VARCHAR(10) — NOT NULL
- option_name — VARCHAR(128) — NOT NULL
- booking_code — VARCHAR(32)
- apply_start — TIMESTAMPTZ
- apply_end — TIMESTAMPTZ
- price — DOUBLE — NOT NULL
- notes — VARCHAR(2048)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMPTZ
price
- id — BIGSERIAL
- promotion_id — BIGINT — NOT NULL
- room_id — BIGINT — NOT NULL
- season — VARCHAR(256)
- apply_start — TIMESTAMPTZ
- apply_end — TIMESTAMPTZ
- price_per_night — DOUBLE — NOT NULL
- breakfast_included — BOOLEAN — NOT NULL
- porterage_included — BOOLEAN — NOT NULL
- minimum_stay — INTEGER — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMPTZ
promotion
- id — BIGSERIAL
- hotel_id — BIGINT — NOT NULL
- promotion_name — VARCHAR(256) — NOT NULL
- booking_code — VARCHAR(32)
- booking_start — TIMESTAMPTZ
- booking_end — TIMESTAMPTZ
- disable_start — TIMESTAMPTZ
- disable_end — TIMESTAMPTZ
- priority — INTEGER — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMPTZ
room
- id — BIGSERIAL
- hotel_id — BIGINT — NOT NULL
- room_name — VARCHAR(128) — NOT NULL
- bed_type — VARCHAR(128)
- min_total — INTEGER — NOT NULL
- max_total — INTEGER — NOT NULL
- max_adults_only — INTEGER — NOT NULL
- max_adults_with_children — INTEGER — NOT NULL
- notes — VARCHAR(2048)
- priority — INTEGER — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMPTZ
semantic_information
- id — BIGSERIAL
- location_id — BIGINT — NOT NULL
- title — VARCHAR(1024) — NOT NULL
- contents — TEXT — NOT NULL
- is_top — BOOLEAN — NOT NULL
- position — INTEGER — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMPTZ