도란도란
테이블 (6)
Category
- category_id — INT(11) — 기본 키 — NOT NULL
- content — TEXT — NOT NULL
Comment
- comment_id — INT(11) — 기본 키 — NOT NULL
- member_id — VARCHAR(30) — 외래 키 → Member.member_id — NOT NULL
- group_id — INT(11) — 외래 키 → Group.group_id — NOT NULL
- content — TEXT
- write_time — DATETIME
Group
- group_id — INT(11) — 기본 키 — NOT NULL
- category_id — INT(11) — 외래 키 → Category.category_id — NOT NULL
- name — VARCHAR(30)
- content — VARCHAR(30)
- deadline_type — INT(11)
- deadline_member — INT(11)
- deadline_time — DATETIME
- status — BOOLEAN
- create_time — DATETIME
- image — VARCHAR(100)
Group_Member
- member_id — VARCHAR(30) — 외래 키 → Member.member_id — NOT NULL
- group_id — INT(11) — 외래 키 → Group.group_id — NOT NULL
- is_founder — BOOLEAN
- member_status — INT(11)
- member_count — INT(11)
Member
- member_id — VARCHAR(30) — 기본 키 — NOT NULL
- password — VARCHAR(30)
- name — VARCHAR(30)
- position — VARCHAR(30)
- grade — INT(11)
- gender — INT(11)
- phone_number — VARCHAR(30)
- image — VARCHAR(100)
Untitled (Request_Member)
- group_id — INT(11) — 외래 키 → Group.group_id — NOT NULL
- Field2 (current_member)
- Field (wait_member)