찾아감

테이블 (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