분실물 도메인

테이블 (13)

Admin (admin)

  • org (Key) — varcahr(225) — 기본 키 — NOT NULL
  • saving (Field) — varchar(225)
  • period (Field2) — varchar(225)

Board (board)

  • board_num (Key) — int — 기본 키 — NOT NULL
  • user_id (FK) — varchar(225) — 외래 키 → User.id — NOT NULL
  • img_key (Key2) — varchar(225) — 외래 키 → Image.Img_key — NOT NULL
  • title (Field3) — varchar(225)
  • cont (Field4) — varchar(1500)
  • view_cnt (Field8) — int
  • created_at (Field10) — timestamp
  • updated_at (Field11) — timestamp

Board_reply (board_reply)

  • reply_num (Key) — int — 기본 키 — NOT NULL
  • board_num (Key2) — int — 외래 키 → Board.board_num — NOT NULL
  • id (Key3) — varchar(225) — 외래 키 → User.id — NOT NULL
  • depth (Field) — int
  • step (Field2) — int
  • date (Field3) — timestamp
  • cont (Field4) — varchar(1000)

Category (categories)

  • id (Key) — int — 기본 키 — NOT NULL
  • name (Field) — varchar(225)

Image (images)

  • Img_key (Key) — varchar(225) — 기본 키 — NOT NULL
  • created_at (Field2) — timestamp
  • url (Field) — varchar(225)

Manager (manager)

  • id (Key) — varchar(225) — 기본 키 — NOT NULL
  • pwd (Field) — varchar(225)

Message (messages)

  • msg_no (Key) — int — 기본 키 — NOT NULL
  • send_user_id (FK) — varchar(225) — 외래 키 → User.id — NOT NULL
  • rec_user_id (Key2) — varchar(225) — 외래 키 → User.id — NOT NULL
  • is_read (Field3) — boolean
  • created_at (Field4) — timestamp

Missing (missing)

  • mis_num (Key) — int — 기본 키 — NOT NULL
  • user_id (FK) — varchar(225) — 외래 키 → User.id — NOT NULL
  • category_id (FK3) — int — 외래 키 → Category.id — NOT NULL
  • Img_key (Key2) — varchar(225) — 외래 키 → Image.Img_key — NOT NULL
  • title (Field3) — varchar(225)
  • cont (Field4) — varchar(1500)
  • location (Field5) — varchar(225)
  • thumb_nail_image (Field7) — varchar(225)
  • view_cnt (Field8) — int
  • created_at (Field10) — timestamp
  • updated_at (Field11) — timestamp

Police (police)

  • act_id (Key) — varchar(225) — 기본 키 — NOT NULL
  • title (Field) — varchar(225)
  • org_id (Field2) — varchar(225)
  • file_path_img (Field3) — varchar(1500)
  • place (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)

Seoul (seoul)

  • act_id (Key) — varchar(225) — 기본 키 — NOT NULL
  • status (Field) — varchar(225)
  • product_name (Field2) — varchar(225)
  • category (Field3) — varchar(225)
  • date (Field4) — timestamp
  • org_name (Field5) — varchar(225)
  • take_place (Field6) — varchar(225)
  • cont (Field7) — varchar(2000)

Seoul_Sector (seoul_sector)

  • num (Key) — int — 기본 키 — NOT NULL
  • name (Field) — varchar(225)
  • loc (Field2) — varchar(225)

User (users)

  • id (Key) — varchar(225) — 기본 키 — NOT NULL
  • Img_key (Key2) — varchar(225) — 외래 키 → Image.Img_key — NOT NULL
  • oauth_id (Field) — int
  • nickname (Field2) — varchar(225)
  • location (Field3) — varchar(225)
  • manner_rank (Field5) — varchar(225)
  • manner_point (Field9) — int
  • created_at (Field6) — timestamp
  • updated_at (Field7) — timestamp
  • message (Field8) — int
  • pwd (Field4) — varchar(225)

UserCnt (usercnt)

  • date (Key) — timestamp — 기본 키 — NOT NULL
  • user_count (Field) — int
  • guest_count (Field2) — int