StudyRoom

테이블 (5)

Untitled (study_group)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(60) — NOT NULL
  • Field (type) — varchar(30) — NOT NULL
  • Field (start_date) — date — NOT NULL
  • Field (end_date) — date — NOT NULL
  • Field (headcount) — tinyint — NOT NULL
  • Field (introduction) — varchar(3000) — NOT NULL
  • Field (is_recruit) — boolean — NOT NULL
  • Field (modified_at) — date — NOT NULL
  • Field (created_at) — date — NOT NULL
  • Field (modified_by) — bigint — NOT NULL

Untitled (participant)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • (member_id) — bigint — 외래 키 → 유저.id — NOT NULL
  • Key (study_group_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (role) — varchar(10) — NOT NULL
  • Field (created_at) — date — NOT NULL
  • Field (modifed_at) — date — NOT NULL
  • Field (modified_by) — bigint — NOT NULL

Untitled (study_application)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • (member_id) — bigint — 외래 키 → 유저.id — NOT NULL
  • Key (study_group_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (status) — varchar(10) — NOT NULL
  • Field (created_at) — date — NOT NULL
  • Field (modified_at) — date — NOT NULL
  • Field (modified_by) — bigint — NOT NULL

Untitled (study_notice)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (study_group_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (article) — varchar(3000) — NOT NULL
  • Field (created_at) — date — NOT NULL
  • Field (modified_at) — date — NOT NULL
  • Field (modified_by) — bigint — NOT NULL

유저 (member)

  • (id) — bigint — 기본 키 — NOT NULL
  • Field (username) — varchar(16) — NOT NULL
  • Field (password) — varchar(68) — NOT NULL
  • Field (email) — varchar(30)
  • Field (name) — varchar(18) — NOT NULL
  • Field (birth) — date
  • Field (gender) — char(1) — NOT NULL
  • Field (profile_image) — varchar(2083)
  • Field (role) — varchar(10) — NOT NULL
  • Field (is_locked) — boolean — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (modifed_at) — datetime — NOT NULL
  • Field (modified_by) — varchar(20) — NOT NULL