ㅁㄴㅇㅁㄴㅇ
Tables (7)
Matching
- id — bigint — Primary key — NOT NULL
- member_id — bigint — NOT NULL — 관리번호
- date — TIMESTAMP — NOT NULL — 매칭 날짜
- opponent — VARCHAR(255)
- status — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
Member
- id — bigint — Primary key — NOT NULL — 관리번호
- email — VARCHAR(255) — NOT NULL — 회원 이메일
- password — VARCHAR(20) — NOT NULL — 회원 PW
- status — VARCHAR(15) — NOT NULL — 비활성화: INACTIVE,정지: SUSPENDED
- role — VARCHAR(10) — NOT NULL — 기본값: USER, 관리자: ADMIN
- nickname — VARCHAR(15) — NOT NULL — 회원 닉네임
- phone — VARCHAR(15) — NOT NULL — 회원 연락처
- birthday — VARCHAR(20) — NOT NULL — 회원 생년월일
- gender — VARCHAR(6) — NOT NULL — 회원 성별
- height — Double — NOT NULL — 회원 키
- region — VARCHAR(30) — NOT NULL — 회원 지역
- department — VARCHAR(50) — NOT NULL
- distance — VARCHAR(30) — NOT NULL — SHORT, LONG
- smoking — VARCHAR(30) — NOT NULL — SMOKER, NONSMOKER
- drinking — VARCHAR(30) — NOT NULL — DRINKER, NONDRINKER
- introduction — VARCHAR(255) — NOT NULL
- preference — VARCHAR(255)
- nondepartment — VARCHAR(255)
- nonstudentid — VARCHAR(30)
- nonage — VARCHAR(30)
- image — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
Post
- id — VARCHAR(255) — Primary key — NOT NULL
- member_id — bigint — Foreign key → Member.id — NOT NULL — 회원 ID
- qa_id — bigint — Foreign key → QA.id — NOT NULL — Q&A 게시글 ID
- report_id — bigint — Foreign key → Report.id — NOT NULL — 신고접수게시글ID
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- title — VARCHAR(255) — NOT NULL
- body — VARCHAR(255) — NOT NULL
QA
- id — bigint — Primary key — NOT NULL
- answerstatus — VARCHAR(3) — YES, NOT
- secret — VARCHAR(4)
- password — VARCHAR(255)
- answer — VARCHAR(255)
Report
- id — bigint — Primary key — NOT NULL
- badMember — bigint — NOT NULL
Review
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → Member.id — NOT NULL — 회원 ID
- qa_id — bigint — Foreign key → QA.id — NOT NULL — Q&A 게시글 ID
- report_id — bigint — Foreign key → Report.id — NOT NULL — 신고접수게시글ID