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