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)