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