cotato-porject

Tables (6)

items

  • id — BIGINT — Primary key
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

purchase_reservations

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • item_id — BIGINT — NOT NULL
  • reserved_at — DATETIME — NOT NULL
  • notify_at — DATETIME — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • sent_at — DATETIME
  • canceled_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_notify_at_status
  • INDEX — idx_reservation_user
  • INDEX — idx_reservation_item

terms_policies

  • id — BIGINT — Primary key
  • code — VARCHAR(50) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • is_required — TINYINT(1) — NOT NULL
  • effective_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_devices

  • id — BIGINT — Primary key
  • user_id — BIGINT — NOT NULL
  • device_type — VARCHAR(20) — NOT NULL
  • push_token — VARCHAR(512) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_user_devices_user

user_terms_agreements

  • id — BIGINT — Primary key
  • user_id — BIGINT — NOT NULL
  • terms_id — BIGINT — NOT NULL
  • agreed_at — DATETIME — NOT NULL
  • agreed_ip — VARCHAR(45)
  • agreed_user_agent — VARCHAR(255)
  • is_agreed — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL