gomin version2
Tables (8)
answer
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- sushi_id — INT — Foreign key → sushi.id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- content — TEXT — NOT NULL
- is_liked — BOOLEAN — NOT NULL
category
- id — INT — Primary key — NOT NULL
- name — VARCHAR(10) — NOT NULL
notification
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- sushi_id — INT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- notification_type — VARCHAR(255)
- message — VARCHAR(255) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- redirect_url — VARCHAR(255) — NOT NULL
share_token
- id — INT — Primary key — NOT NULL
- sushi_id — INT — Foreign key → sushi.id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- token — VARCHAR(255) — NOT NULL
sushi
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- category_id — INT
- sushi_type_id — INT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- expire_time — DATETIME(6) — NOT NULL
- max_answers — INT — NOT NULL
- remaining_answers — INT — NOT NULL
- is_closed — BOOLEAN — NOT NULL
sushi_exposure
- id — BIGINT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- sushi_id — INT — Foreign key → sushi.id — NOT NULL
- timestamp — DATETIME(6)
sushi_type
- id — INT — Primary key — NOT NULL
- name — VARCHAR(20) — NOT NULL
user
- id — INT — Primary key — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
- deleted_at — DATETIME(6)