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