3Dine
Tables (7)
asset_derivatives
- id — BIGINT — Primary key — NOT NULL
- asset_id — BIGINT — NOT NULL
- purpose — ENUM('thumbnail','preview','menu_scan','usdz') — NOT NULL
- mime_type — VARCHAR(64) — NOT NULL
- storage_bucket — VARCHAR(128) — NOT NULL
- storage_key — VARCHAR(512) — NOT NULL
- bytes_size — BIGINT — NOT NULL
- width — INT
- height — INT
- created_at — DATETIME — NOT NULL
menu_categories
- category_id — INT — Primary key — NOT NULL
- menu_board_id — INT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(1000)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
menu_items
- menu_item_id — INT — Primary key — NOT NULL
- menu_board_id — INT — NOT NULL
- menu_category_id — INT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(2000)
- price — DECIMAL(10,2)
- is_available — TINYINT(1) — NOT NULL
- thumbnail_asset_id — BIGINT
- model_asset_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- /* — 같은
- menu_board_id) — ON
owners
- owner_id — INT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- owner_name — VARCHAR(100) — NOT NULL
- restaurant_id — INT — NOT NULL
- approved_at — DATETIME
ownership_requests
- ownership_request_id — INT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- restaurant_id — INT
- requested_name — VARCHAR(255)
- requested_business_no — VARCHAR(50)
- admin_id — INT
- is_approved — ENUM('PENDING','APPROVED','REJECTED') — NOT NULL
- request_at — DATETIME — NOT NULL
- response_at — DATETIME
refresh_tokens
- token_id — BIGINT — Primary key — NOT NULL
- token — VARCHAR(512) — NOT NULL
- user_id — BIGINT — NOT NULL
- expires_at — DATETIME — NOT NULL
- revoked — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- replaced_by_token — VARCHAR(512)
restaurant_hours
- hours_id — INT — Primary key — NOT NULL
- restaurant_id — INT — NOT NULL
- day_of_week — TINYINT — NOT NULL
- /* — 0~6
- close_time — TIME
- overnight — TINYINT(1) — NOT NULL
- is_closed — TINYINT(1) — NOT NULL