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)