그로우룸
테이블 (13)
Untitled (user)
- Key (user_id) — bigint — 기본 키 — NOT NULL — auto_increment
- Field (image) — varchar(2048) — NOT NULL
- Field (create_at) — datetime — NOT NULL
- Field (update_at) — datetime — NOT NULL — on update current_timestamp
- Field (email) — varchar(255) — NOT NULL
- Field (password) — varchar(255) — NOT NULL
- Field (is_withdraw) — tinyint — NOT NULL
- Field (withdraw_at) — datetime
- Field (nickname) — varchar(20) — NOT NULL
Untitled (growroom)
- Key (growroom_id) — bigint — 기본 키 — NOT NULL — auto_increment
- Key (user_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
- Field (is_popular) — tinyint — NOT NULL
- Field (like_count) — int — NOT NULL
- Field (is_end) — tinyint — NOT NULL
- Field (start_at) — datetime — NOT NULL
- Field (end_at) — datetime — NOT NULL
- Field (create_at) — datetime — NOT NULL
- Field (update_at) — datetime — NOT NULL — on update current_timestamp
- Field (title) — varchar(255) — NOT NULL
- Field (content) — text — NOT NULL
- Field (view_count) — int — NOT NULL
- Key (activity_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
- Key (member_count_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
- Key (period_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
Untitled (comment)
- Key (comment_id) — bigint — 기본 키 — NOT NULL — auto_increment
- Key (user_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
- Key (parent_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
- Field (is_delete) — tinyint — NOT NULL
- Field (create_at) — datetime — NOT NULL
- Field (update_at) — datetime — NOT NULL — on update current_timestamp
- Field (content) — text — NOT NULL
- Key (growroom_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL — auto_increment
Untitled (activity)
- Key (activity_id) — bigint — 기본 키 — NOT NULL — auto_increment
- Field (name) — varchar(20) — NOT NULL
Untitled (member_count)
- Key (member_count_id) — bigint — 기본 키 — NOT NULL — auto_increment
- Field (number) — int — NOT NULL
Untitled (period)
- Key (period_id) — bigint — 기본 키 — NOT NULL
- Field (name) — varchar(20) — NOT NULL
Untitled (category)
- Key (category_id) — bigint — 기본 키 — NOT NULL — auto_increment
- Field (name) — NOT NULL
Untitled (growroom_category)
- Key (growroom_subject_id) — bigint — 기본 키 — NOT NULL — auto_increment
- Key (subject_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
- Key (growroom_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
Untitled (like_growroom)
- Key (like_growroom_id) — bigint — 기본 키 — NOT NULL — auto_increment
- Key (user_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
- Key (growroom_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
Untitled (participant)
- Key (participant_id) — bigint — 기본 키 — NOT NULL — auto_increment
- Key (user_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
- Key (growroom_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
- Field (create_at) — datetime — NOT NULL
- Field (end_at) — datetime — NOT NULL
- Field (is_end) — tinyint — NOT NULL
- Field (is_bestup) — tinyint — NOT NULL
- Field (is_50up) — tinyint — NOT NULL
- Field (like_count) — int — NOT NULL
Untitled (participate_time)
- Key (participate_time_id) — bigint — 기본 키 — NOT NULL — auto_increment
- Key (user_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
- Field (total_time) — time — NOT NULL
- Field (month_time) — time — NOT NULL
- Field (day_time) — time — NOT NULL
Untitled (like_user)
- Key (like_user_id) — bigint — 기본 키 — NOT NULL — auto_increment
- Key (subject_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
- Key (target_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
- Field (create_at) — datetime — NOT NULL
Untitled (todo_list)
- Key (todo_list_id) — bigint — 기본 키 — NOT NULL — auto_increment
- Key (user_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — auto_increment
- Field (start_at) — datetime — NOT NULL
- Field (end_at) — datetime — NOT NULL
- Field (content) — varchar(255) — NOT NULL
- Field (is_complete) — tinyint — NOT NULL