ㅁㄴㅇㅁㄴㅇ

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

Notice

  • CREATE — TABLE

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