그로우룸

테이블 (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