goalting

테이블 (5)

Untitled (role)

  • Key (role_id) — BIGINT — 기본 키 — NOT NULL
  • Field (role) — ENUM

Untitled (user_autority)

  • Key (user_authority) — INT — 기본 키 — NOT NULL
  • Field (user_id) — INT
  • Field2 (role_id) — INT

Untitled2 (user_goal)

  • Key (user_goal_id) — INT — 기본 키 — NOT NULL
  • Field (user_id) — INT — NOT NULL
  • Field2 (goal_id) — INT — NOT NULL
  • Field3 (user_yn) — CHAR(1) — NOT NULL
  • Field4 (created) — DATETIME — NOT NULL
  • Field (updated) — DATETIME — NOT NULL

user (goal)

  • Key (goal_id) — INT — 기본 키 — NOT NULL
  • Field (title) — VARCHAR(255) — NOT NULL
  • Field2 (summary) — VARCHAR(255) — NOT NULL
  • Field3 (host_id) — VARCHAR(255) — NOT NULL
  • Field4 (due_date) — DATETIME — NOT NULL
  • Field5 (goalting_period) — INT — NOT NULL
  • Field6 (enter_key) — VARCHAR(255) — NOT NULL — UNIQUE KEY
  • Field7 (use_yn) — CHAR(1) — NOT NULL — default 'Y'
  • Field (created) — DATETIME — NOT NULL
  • Field2 (updated) — DATETIME — NOT NULL

유저 (user)

  • 유저 id (user_id) — BIGINT — 기본 키 — NOT NULL
  • (email) — VARCHAR(255)
  • Field2 (nickname) — VARCHAR(255)
  • Field3 (password) — VARCHAR(255)
  • Field4 (profile_image) — VARCHAR(255)
  • Field (created) — DATETIME — NOT NULL
  • Field2 (updated) — DATETIME — NOT NULL