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