분실물 도메인
테이블 (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