reservation

Tables (18)

account (Untitled2)

  • account_id (Key) — string — Primary key — NOT NULL
  • company_id (Key2) — number — Foreign key → company.company_id — NOT NULL
  • ... (Field)

account_reservation_profile (Untitled10)

  • accountId (Key) — string — Foreign key → account.account_id — NOT NULL
  • order (Field) — number
  • is_visible (Field2) — boolean
  • position (Field3) — string
  • description (Field4) — string
  • memo (Field5) — string
  • profile_image_url (Field6) — string
  • keywords (Field7) — array
  • sns (Field8) — json

account_style (Untitled6)

  • style_id (Key) — number — Primary key — NOT NULL
  • title (Field) — string
  • accountId (Key2) — string — Foreign key → account_reservation_profile.accountId — NOT NULL
  • description (Field2) — string

account_style_images (Untitled16)

  • image_id (Key) — number — Primary key — NOT NULL
  • image_url (Field) — string
  • order (Field2) — number
  • style_id (Key2) — number — Foreign key → account_style.style_id — NOT NULL

company (CopyOfUntitled)

  • company_id (Key) — number — Primary key — NOT NULL
  • ... (Field)

company_menu (Untitled4)

  • menu_id (Key) — number — Primary key — NOT NULL
  • title (Field) — string
  • price (Field2) — number
  • description (Field4) — string
  • currency (Field5) — string
  • order (Field3) — number
  • category_id (Key2) — number — Foreign key → company_menu_category.category_id — NOT NULL

company_menu_category (Untitled3)

  • category_id (Key) — number — Primary key — NOT NULL
  • color (Field2) — string
  • order (Field) — number
  • title (Field3) — string
  • company_id (Key2) — number — Foreign key → company.company_id — NOT NULL

company_reservation_profile (Untitled)

  • company_id (Key) — number — Foreign key → company.company_id — NOT NULL
  • description (Field3) — string
  • sns (Field4) — json
  • web_site (Field5) — string
  • keywords (Field) — string
  • is_parking_available (Field2) — boolean
  • currency (Field7) — enum
  • is_reservable (Field8) — boolean
  • holiday_config (Field9) — array
  • analysis_types (Field6) — enum
  • amenities (Field10) — object

company_reservation_profile_thumbnail (Untitled9)

  • image_id (Key) — number — Primary key — NOT NULL
  • image_url (Field) — string
  • type (Field3) — image|video
  • order (Field2) — number
  • company_id (Key2) — number — Foreign key → company_reservation_profile.company_id — NOT NULL

holiday_definition (Untitled14)

  • holiday_id (Key) — Primary key — NOT NULL
  • country_code (Field) — string
  • state_code (Field2) — string
  • name (Field4) — string
  • type (Field5)

payment (Untitled12)

  • payment_id (Key) — Primary key — NOT NULL
  • Field
  • slot_id (Key2) — number — Foreign key → reservation.reservation_id — NOT NULL
  • ... (Field2)

reservation (Untitled7)

  • reservation_id (Key) — number — Primary key — NOT NULL
  • start_date_time (Field) — datetime
  • end_date_time (Field2) — datetime
  • status (Field3) — enum
  • visit_count (Field8) — number
  • account_id (Key2) — string — Foreign key → account.account_id — NOT NULL
  • user_id (Key3) — string — Foreign key → user.user_id — NOT NULL
  • menu_id (Key4) — number — Foreign key → company_menu.menu_id — NOT NULL

reservation_account_has_menu (CopyOfUntitled4)

  • id (Key) — number — Primary key — NOT NULL
  • account_id (Key2) — string — Foreign key → account.account_id — NOT NULL
  • menu_id (Key3) — number — Foreign key → company_menu.menu_id — NOT NULL

reservation_operating_time (Untitled5)

  • business_time_id (Key3) — number — Primary key — NOT NULL
  • timezone (Field)
  • start_time (Field2) — time
  • end_time (Field3) — time
  • week_day (Field5) — enum
  • account_id (Key) — string — Foreign key → account.account_id — NOT NULL
  • company_id (Key2) — number — Foreign key → company.company_id — NOT NULL

reservation_operating_time_exception (Untitled15)

  • id (Key) — number — Primary key — NOT NULL
  • date (Field) — date
  • start_time (Field2) — time
  • end_time (Field3) — time
  • title (Field4) — string
  • exceptionType (Field5) — enum
  • company_id (Key2) — number — Foreign key → company.company_id — NOT NULL
  • account_id (Key3) — string — Foreign key → account.account_id — NOT NULL

reservation_send_message (Untitled13)

  • reservation_send_message_id (Key) — number — Primary key — NOT NULL
  • Field

review (Untitled11)

  • review_id (Key) — number — Primary key — NOT NULL
  • content (Field) — string
  • score (Field2) — number
  • slot_id (Key2) — number — Foreign key → reservation.reservation_id — NOT NULL

user (Untitled8)

  • user_id (Key) — string — Primary key — NOT NULL
  • user_name (Field) — string
  • ... (Field2)