찾아감
테이블 (17)
board
- board_num (Key) — int — 기본 키 — NOT NULL
- img_key (Key2) — varchar(255) — 외래 키 → image.img_key — NOT NULL
- nickname (Key32) — varchar(225) — 외래 키 → user.nickname — NOT NULL
- title (Field3) — varchar(225)
- cont (Field4) — varchar(1500)
- view_cnt (Field5) — int
- create_at (Field6) — timestamp
- user_nickname (Field7) — varchar(255)
board_reply
- reply_num (Key) — int — 기본 키 — NOT NULL
- board_num (Field) — int
- id (Field2) — varchar(225)
- depth (Field3) — int
- step (Field4) — int
- date (Field5) — timestamp
- cont (Field6) — varchar(225)
- nickname (Key3) — varchar(225) — 외래 키 → user.nickname — NOT NULL
faq
- num (Key) — int — 기본 키 — NOT NULL
- title (Field) — varchar(225)
- cont (Field2) — varchar(1500)
image
- img_key (Key) — varchar(255) — 기본 키 — NOT NULL
- created_at (Field) — timestamp
- url (Field2) — varchar(1500)
message
- mag_no (Key) — int — 기본 키 — NOT NULL
- rec_user_nickname (Key32) — varchar(225) — 외래 키 → user.nickname — NOT NULL
- send_user_nickname (Key3) — varchar(225) — 외래 키 → user.nickname — NOT NULL
- room_name (Field) — varchar(225)
- cont (Field4) — varchar(1500)
- created_at (Field5) — timestamp
- is_read (Field6) — int
missing
- mis_num (Key) — int — 기본 키 — NOT NULL
- nickname (Key32) — varchar(225) — 외래 키 → user.nickname — NOT NULL
- img_key (Key2) — varchar(255) — 외래 키 → image.img_key — NOT NULL
- user_id (Field) — varchar(225)
- category_id (Field2) — int
- major_category (Field3) — varchar(225)
- minor_category (Field4) — varchar(225)
- title (Field6) — varchar(225)
- cont (Field7) — varchar(1500)
- location (Field8) — varchar(225)
- thuml_nail_image (Field9) — varchar(225)
- view_cnt (Field10) — int
- created_at (Field11) — timestamp
- updated_at (Field12) — timestamp
pickup
- pick_num (Key) — int — 기본 키 — NOT NULL
- img_key (Key2) — varchar(255) — 외래 키 → image.img_key — NOT NULL
- user_id (Field) — varchar(225)
- category_id (Field2) — int
- major_category (Field3) — varchar(225)
- minor_category (Field4) — varchar(225)
- title (Field6) — varchar(225)
- cont (Field7) — varchar(1500)
- location (Field8) — varchar(225)
- thumb_nail_image (Field9) — varchar(225)
- view_cnt (Field10) — int
- created_at (Field11) — timestamp
- updated_at (Field12) — timestamp
police
- police_key (Key) — varchar(255) — 기본 키 — NOT NULL
- sec_num (Key2) — int — 외래 키 → police_sector.sec_num — NOT NULL
- atc_id (Field) — varchar(225)
- title (Field2) — varchar(225)
- file_path_img (Field3) — varchar(1500)
- Field4 — varchar(225)
- date (Field5) — timestamp
- org_name (Field6) — varchar(225)
- org_tel (Field7) — varchar(225)
- product_name (Field8) — varchar(225)
- cont (Field9) — varchar(2000)
- fdSn (Field10) — int
- status (Field11) — varchar(255)
- addr (Field12) — varchar(1500)
police_sector
- sec_num (Key) — int — 기본 키 — NOT NULL
- main (Field) — varchar(225)
- center (Field2) — varchar(225)
- name (Field3) — varchar(225)
- sep (Field4) — varchar(225)
- tel (Field5) — varchar(225)
- addr (Field6) — varchar(1500)
public_lost_items
- id_plus (Key) — varchar(255) — 기본 키 — NOT NULL
- act_id (Field) — varchar(255)
- gain_num (Field2) — varchar(255)
- dept (Field3) — varchar(255)
- img_url (Field4) — varchar(2000)
- name (Field5) — varchar(255)
- content (Field6) — varchar(2000)
- date (Field7) — timestamp
- major_category (Field8) — varchar(255)
- minor_category (Field9) — varchar(255)
- tel (Field10) — varchar(255)
- front_tel (Field11) — varchar(255)
public_police_lost_items
- id_plus (Key) — varchar(255) — 기본 키 — NOT NULL
- act_id (Field) — varchar(255)
- gain_num (Field2) — varchar(255)
- dept (Field3) — varchar(255)
- img_url (Field4) — varchar(2000)
- name (Field5) — varchar(255)
- content (Field6) — varchar(2000)
- date (Field7) — timestamp
- major_category (Field8) — varchar(255)
- minor_category (Field9) — varchar(255)
- tel (Field10) — varchar(255)
- front_tel (Field11) — varchar(255)
qna
- num (Key) — int — 기본 키 — NOT NULL
- nickname (Key3) — varchar(225) — 외래 키 → user.nickname — NOT NULL
- title (Field2) — varchar(225)
- cont (Field3) — varchar(1500)
- qna_date (Field4) — timestamp
- qna_update (Field5) — timestamp
- qna_status (Field6) — int
- qna_group (Field7) — int
- qna_step (Field8) — int
- qna_indent (Field9) — int
seoul
- atc_id (Key) — varchar(225) — 기본 키 — NOT NULL
- org_name (Key2) — varchar(255) — 외래 키 → seoul_dept.name — NOT NULL
- status (Field) — varchar(225)
- product_name (Field2) — varchar(255)
- category (Field3) — varchar(225)
- date (Field4) — timestamp
- take_place (Field6) — varchar(225)
- cont (Field7) — varchar(2000)
seoul_dept
- name (Key) — varchar(255) — 기본 키 — NOT NULL
- loc (Field) — varchar(255)
- tel (Field2) — varchar(255)
unique_categories
- major_category (Key) — varchar(255) — 기본 키 — NOT NULL
- minor_category (Key2) — varchar(255) — 기본 키 — NOT NULL
user
- id (Key) — varchar(225) — 기본 키 — NOT NULL
- nickname (Key3) — varchar(225) — 기본 키 — NOT NULL
- img_key (Key2) — varchar(255) — 외래 키 → image.img_key — NOT NULL
- oauth_id (Field2) — int
- location (Field3) — varchar(225)
- manner_rank (Field4) — varchar(225)
- manner_point (Field5) — int
- created_at (Field6) — timestamp
- updated_at (Field7) — timestamp
- message (Field8) — int
- pwd (Field9) — varchar(225)
userCnt
- Key2 — int — 기본 키 — NOT NULL
- user_count (Field) — int — NOT NULL
- guest_count (Field2) — int
- join_count (Field3) — int
- Field4 — timestamp