PLUG_ERD_V2
Tables (3)
Comment
- comment_id — auto increment — Primary key — NOT NULL
- content — text — NOT NULL
- parent_comment — int
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- member_id — varchar(10)
- board_id — varchar(10) — NOT NULL
- Clike_count — int
Member
- Key (member_id) — varchar(10) — Primary key — NOT NULL
- name — varchar(10) — NOT NULL
- password — varchar(20) — NOT NULL
- email — varchar(10) — NOT NULL
- Field4 (gender) — varchar(10) — NOT NULL
- state — varchar(10) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- user_no — auto increment — NOT NULL
Member info
- user_no — auto increment — Primary key — NOT NULL
- Key (member_id) — varchar(10) — Foreign key → Member.Key — NOT NULL
- hobby — varchar(10) — NOT NULL
- MBTI — varchar(10) — NOT NULL
- Data1 — int — NOT NULL — 자기소개서 답변
- Data2 — int — NOT NULL — 자기소개서 답변
- DataN — int
- Matching — boolean — NOT NULL
- HashTag — varchar(10)