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