rating_my_neighbor

Tables (9)

User (유저)

  • user_id (유저PK) — BIGINT — Primary key — NOT NULL
  • locate_id (지역PK) — BIGINT — Foreign key → location.locate_id — NOT NULL
  • user_account (유저ID) — varchar(30) — NOT NULL — unique
  • user_fw (유저FW) — varchar(30) — NOT NULL
  • name (성함) — varchar(10) — NOT NULL
  • phone_num (전화번호) — char(13) — NOT NULL — 010-xxxx-xxxx 형태
  • created_at (가입일) — DATETIME — NOT NULL

c_board_pic (CopyOf게시판 사진)

  • name (사진이름) — varchar(150) — Primary key — NOT NULL
  • cb_id (민게PK) — BIGINT — Foreign key → complaint_board.cb_id — NOT NULL

c_report (민원신고)

  • c_report_id (민게신고PK) — BIGINT — Primary key — NOT NULL
  • created_at (작성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME
  • state (처리여부) — tinyint — NOT NULL
  • content (신고내용) — varchar(400) — NOT NULL
  • user_id (신고자PK) — BIGINT — Foreign key → manager.user_id — NOT NULL
  • cb_id (민게PK) — BIGINT — Foreign key → complaint_board.cb_id — NOT NULL
  • locate_id (지역PK) — BIGINT — Foreign key → location.locate_id — NOT NULL

complaint_board (민원게시판)

  • cb_id (민게PK) — BIGINT — Primary key — NOT NULL
  • user_id (작성자PK) — BIGINT — Foreign key → User.user_id — NOT NULL
  • title (제목) — varchar(30) — NOT NULL
  • content (내용) — varchar(400) — NOT NULL
  • created_at (작성일) — DATETIME — NOT NULL
  • locate_id (지역PK) — BIGINT — Foreign key → location.locate_id — NOT NULL

f_board_pic (게시판 사진)

  • name (사진이름) — varchar(150) — Primary key — NOT NULL
  • fb_id (자게PK) — BIGINT — Foreign key → free_board.fb_id — NOT NULL

f_report (신고)

  • f_report_id (자게신고PK) — BIGINT — Primary key — NOT NULL
  • created_at (작성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME
  • state (처리여부) — tinyint — NOT NULL
  • content (신고내용) — varchar(400) — NOT NULL
  • user_id (신고자PK) — BIGINT — Foreign key → User.user_id — NOT NULL
  • fb_id (자게PK) — BIGINT — Foreign key → free_board.fb_id — NOT NULL
  • locate_id (지역PK) — BIGINT — Foreign key → location.locate_id — NOT NULL

free_board (자유게시판)

  • fb_id (자게PK) — BIGINT — Primary key — NOT NULL
  • user_id (작성자PK) — BIGINT — Foreign key → User.user_id — NOT NULL
  • title (제목) — varchar(30) — NOT NULL
  • content (내용) — varchar(400) — NOT NULL
  • created_at (작성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME

location (지역)

  • locate_id (지역PK) — BIGINT — Primary key — NOT NULL
  • name (지역이름) — barchar(100) — NOT NULL

manager (관리자)

  • user_id (유저PK) — BIGINT — Foreign key → User.user_id — NOT NULL
  • locate_id (지역PK) — BIGINT — Foreign key → location.locate_id — NOT NULL