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