niche project
테이블 (8)
게시판 (article)
- article_sid (Key2) — bigint — 기본 키 — NOT NULL
- user_id (Key) — varchar — 외래 키 → 유저정보.user_id — NOT NULL
- title (Field) — varchar
- category (Field2) — varchar
- contents (Field3) — longtext
- created_at (Field4) — timestamp
- updated_at (Field5) — timestamp
유저정보 (users)
- user_id (Key) — varchar — 기본 키 — NOT NULL
- nickname (Field2) — varchar — NOT NULL
- location (Field3) — varcher — NOT NULL
- profile_url (Field4) — varchar
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- status (Field7) — boolean
- user_type (Field) — varchar
작업 지원 (applied_history)
- company_sid (Key) — bigint — 외래 키 → 회사 정보.company_sid — NOT NULL
- user_id (Key2) — varchar — 외래 키 → 회사 정보.user_id — NOT NULL
- article_sid — bigint — 외래 키 → 작업요청 게시판.article_sid — NOT NULL
- user_id (Key3) — varchar — 외래 키 → 작업요청 게시판.user_id — NOT NULL
- contents (Field) — varchar
- selected_yn (Field2) — boolean
작업요청 게시판 (request_contents)
- article_sid — bigint — 기본 키 — NOT NULL
- user_id (Key) — varchar — 외래 키 → 유저정보.user_id — NOT NULL
- uploaded_picture_url (Field) — varchar
- contents (Field4) — longtext
- title (Field5) — varchar
- purpose (Field6) — longtext
- target_area (Field7) — varchar
- target_size (Field10) — varchar
- budget_limit (Field8) — varchar
- address (Field9) — varchar
- created_at (Field2) — timestamp
- updated_at (Field3) — timestamp
- requirement (Field11) — text
- start_at (Field12) — date
- end_at (Field13) — date
코멘트 (comments)
- Comment_sid (Key) — bigint — 기본 키 — NOT NULL
- article_sid — bigint — 외래 키 → 작업요청 게시판.article_sid — NOT NULL
- comment (Field) — longtext
- created_at (Field2) — timestamp
- updated_yn (Field3) — boolean
- created_by (Field4) — varchar
회사 관련 자료 (company_file)
- company_sid (Key2) — bigint — 외래 키 → 회사 정보.company_sid — NOT NULL
- user_id (Key22) — varchar — 외래 키 → 회사 정보.user_id — NOT NULL
- Registration (Field) — file
- license (Field2) — file
- cetification (Field3) — file
- pr_file (Field4) — file
회사 작업 이력 (company_history)
- history_sid (Key3) — bigint — 기본 키 — NOT NULL
- company_sid (Key) — bigint — 외래 키 → 회사 정보.company_sid — NOT NULL
- id (Key2) — varchar — 외래 키 → 회사 정보.user_id — NOT NULL
- location (Field) — varcher
- history_picture_url (Field2) — varchar
- rating (Field3) — varchar
- work_start_date (Field5) — date
- work_end_date (Field6) — date
- text (Field7) — longtext
- estimated_budget (Field8) — bigint
- final_budget (Field9) — bigint
- work_type (Field10) — varchar
- target_area (Field11) — varchar
- created_at (Field4) — timestamp
- client_review (Field12) — longtext
회사 정보 (company_info)
- company_sid (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — varchar — 외래 키 → 유저정보.user_id — NOT NULL
- name (Field) — varchar
- manner (Field2) — double
- company_status (Field5) — varchar
- employee_count (Field6) — int
- sales_volume (Field7) — bigint
- established_at (Field8) — int
- representative (Field9) — varchar
- location (Field10) — varchar
- work_count (Field11) — int
- text (Field12) — longtext
- phone_number (Field14) — varchar
- email (Field15) — varchar
- company_category (Field13) — varchar
- created_at (Field3) — timestamp
- updated_at (Field4) — timestamp