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