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 — 유저 수정일