gratz
Tables (5)
event
- Key (id) — LONG — Primary key — NOT NULL
- Key (user_id) — LONG — Foreign key → user.Key — NOT NULL
- Field (theme) — VARCHAR(10)
- Field (wait_time) — TIMESTAMP
- Field (d_day_name) — VARCHAR(45)
- Field (d_day_date) — TIMESTAMP
- Field (d_day_description) — VARCHAR(200)
- Field (created_date) — TIMESTAMP — 이벤트 생성날짜
message
- Key (id) — long — Primary key — NOT NULL — message 아이디
- Key (id2) — LONG — Foreign key → present.Key — NOT NULL
- Key (id22) — LONG — Foreign key → present.Key — NOT NULL
- Key (user_id) — LONG — Foreign key → present.Key — NOT NULL
- Field (nickname) — VARCHAR
- Field (text) — TEXT
- Field (image_url) — VARCHAR (200)
- Field (created_date) — TIMESTAMP
- Field (public) — TINIINT(1)
present (선물)
- Key (id) — LONG — Primary key — NOT NULL
- Key (event_id) — LONG — Foreign key → event.Key — NOT NULL
- Key (user_id) — LONG — Foreign key → event.Key — NOT NULL
- Field (name) — VARCHAR(20)
- Field (type) — VARCHAR(10)
scrap (Untitled)
- Key (event_id) — LONG — Foreign key → event.Key — NOT NULL
- Key (user_id) — LONG — Foreign key → event.Key — NOT NULL
- Key (id2) — LONG — Foreign key → user.Key — NOT NULL — 유저 아이디
user
- Key (id) — LONG — Primary key — NOT NULL — 유저 아이디
- Field (email) — VARCHAR(20) — 사용자 이메일
- Field (nickname) — VARCHAR(8)
- Field (created_date) — TIMESTAMP
- Field (modified_date) — TIMESTAMP — 유저 수정일