YEQA
Tables (4)
item
- item_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- type — VARCHAR(30) — NOT NULL
- description — TEXT
- favorite — BOOLEAN
- is_locked — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
item_field
- field_id — BIGINT — Primary key — NOT NULL
- item_id — BIGINT — Foreign key → item.item_id — NOT NULL
- field_name — VARCHAR(100) — NOT NULL
- field_value — TEXT
- field_type — VARCHAR(30)
- sort_order — INT
- created_at — DATETIME
- updated_at — DATETIME
social_account
- social_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
- created_at — DATETIME
users
- user_id — BIGINT — Primary key — NOT NULL
- nickname — VARCHAR(50)
- email — VARCHAR(100)
- profile_image — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME