FB

Tables (8)

Boost (후원 정보)

  • boost_id (Key) — Primary key — NOT NULL
  • company_id (Key2) — bigint — Foreign key → Company.company_id — NOT NULL
  • amount (Field) — bigint
  • project_id (Key3) — Foreign key → Project.project_id — NOT NULL
  • user_id (Key22) — bigint — Foreign key → Project.user_id — NOT NULL

Company (기업)

  • company_id (Key) — bigint — Primary key — NOT NULL
  • password (Field) — varchar(1000)
  • business_number (Field2) — varchar(55)

Follow (팔로잉/팔로워)

  • follow_id (Key) — bigint — Primary key — NOT NULL
  • follower_id (Field) — bigint
  • following_id (Field2) — bigint
  • created_at (Field3) — datetime(6)
  • user_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL

Like (좋아요)

  • like_id (Key) — bigint — Primary key — NOT NULL
  • project_id (Key3) — Foreign key → Project.project_id — NOT NULL
  • user_id (Key22) — bigint — Foreign key → Project.user_id — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL

Project (프로젝트)

  • project_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
  • main_title (Field) — varchar(50)
  • sub_title (Field2) — varchar(100)
  • target_amount (Field3) — bigint
  • funding_start_date (Field4) — datetime(6)
  • funding_end_date (Field5) — datetime(6)
  • introduction (Field7) — varchar(300)
  • category (Field8) — enum
  • image (Field9) — varchar(100)
  • region (Field6) — varchar(30)
  • budget_description (Field10) — varchar(1000)
  • schedule_description (Field11) — varchar(1000)
  • team_introduction (Field12) — varchar(1000)
  • account (Field14) — varchar(30)
  • created_at (Field15) — datetime(6)
  • updated_at (Field16) — datetime(6)
  • progress (Field17) — enum

Proposal (제안서)

  • proposal_id (Key) — bigint — Primary key — NOT NULL
  • project_id (Key2) — Foreign key → Project.project_id — NOT NULL
  • user_id (Key22) — bigint — Foreign key → Project.user_id — NOT NULL
  • company_id (Key3) — bigint — Foreign key → Company.company_id — NOT NULL
  • title (제목) — varchar(55)
  • file (파일) — text
  • content (내용) — varchar(555)
  • status (프로젝트 상태) — enum
  • viewed_at (확인상태) — boolean
  • created_at (생성일) — datetime(6)
  • updated_at (수정일) — datetime(6)

User (유저)

  • user_id (Key) — bigint — Primary key — NOT NULL
  • name (Field10) — varchar(45)
  • email (Field) — varchar(55)
  • image (Field5) — varchar(1000)
  • type (Field2) — enum
  • link (Field6) — varchar(100)
  • title (Field7) — varchar(100)
  • tag (Field9) — varchar(20)
  • content (Field8) — varchar(100)
  • created_at (Field3) — datetime(6)
  • updated_at (Field4) — datetime(6)
  • company_id (Key2) — bigint — Foreign key → Company.company_id — NOT NULL

review (마감 후기)

  • review_id (Key) — bigint — Primary key — NOT NULL
  • project_id (Key2) — Foreign key → Project.project_id — NOT NULL
  • user_id (Key22) — bigint — Foreign key → Project.user_id — NOT NULL
  • image (Field) — text
  • description (Field2) — text
  • type (Field4) — enum
  • updated_at (Field5) — datetime(6)
  • created_at (Field3) — datetime(6)