한끼즈 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