허니문 리조트

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