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