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