한끼즈 ERD

테이블 (6)

Untitled (participation)

  • id (flag_id) — int — 외래 키 → party.id — NOT NULL
  • email (participant_email) — varchar(255) — 외래 키 → user.email — NOT NULL
  • Field (last_updated) — datetime — NOT NULL
  • Field (date_created) — datetime — NOT NULL
  • Field (status) — varchar(28) — NOT NULL

Untitled (user_manner)

  • email (user_email) — varchar(255) — 외래 키 → user.email — NOT NULL
  • Field (participacation_score) — int — NOT NULL

party (flag)

  • id — int — 기본 키 — NOT NULL
  • email (host_email) — varchar(255) — 외래 키 → user.email — NOT NULL
  • date_created — datetime — NOT NULL
  • location — varchar(255) — NOT NULL
  • meeting_time — datetime — NOT NULL
  • Field (paricipant_count) — int — NOT NULL
  • limit_number (limit_participantNumber) — int — NOT NULL
  • Field (limit_age) — int — NOT NULL
  • Field (limit_gender) — varchar(3)
  • title — varchar(255) — NOT NULL
  • Field (text) — longtext — NOT NULL
  • Field (last_updated) — datetime — NOT NULL
  • Field (enabled) — bit(1) — NOT NULL
  • Field (food_category) — varchar(255)
  • Field (status) — varchar(14) — NOT NULL

role

  • id (code) — int — 기본 키 — NOT NULL
  • authority — varchar(255) — NOT NULL

user

  • email — varchar(255) — 기본 키 — NOT NULL
  • password — varchar(255) — NOT NULL
  • last_password_changed — datetime — NOT NULL
  • password_expired — bit(1) — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • date_created — datetime — NOT NULL
  • account_locked — bit(1) — NOT NULL
  • Field (account_expired) — bit(1) — NOT NULL
  • enabled — bit(1) — NOT NULL
  • withdraw — bit(1) — NOT NULL
  • date_withdraw — datetime

user_role

  • user_email — varchar(255) — 외래 키 → user.email — NOT NULL
  • role_id — int — 외래 키 → role.id — NOT NULL