WAT
Tables (6)
FundingBoard (게시물)
- board_id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — varchar(30) — Foreign key → User.user_id — NOT NULL
- title (Field) — varchar(255)
- category (Field2) — varchar(30)
- language_text (Field3) — varchar(30)
- target (Field4) — varchar(30)
- intro (Field5) — text
- file_name (Field12) — varchar(30)
- background_text (Field6) — text
- object_text (Field7) — text
- develop_content (Field8) — text
- func_text (Field13) — text
- regi_date (Field11) — date
- start_date (Field17) — date
- end_date (Field18) — date
FundingBoardCrew (펀딩 게시물 팀원)
- board_id (Key) — int — Foreign key → FundingBoard.board_id — NOT NULL
- front_crew (Field) — int
- back_crew (Field2) — int
FundingBoardPrice (펀딩 게시물 가격)
- board_id (Key) — int — Foreign key → FundingBoard.board_id — NOT NULL
- func_a_price (Field) — int
- func_b_price (Field2) — int
- func_c_price (Field3) — int
- fund_goal_price (Field4) — int
- fund_total_price (Field5) — int
JoinFund (펀딩 참여)
- jf_ID (Key2) — int — Primary key — NOT NULL
- user_id (Key23) — varchar(30) — Foreign key → User.user_id — NOT NULL
- board_id (Key) — int — Foreign key → FundingBoardPrice.board_id — NOT NULL
- fund_price (Field2) — int
- fund_join_list (Field3) — varchar(40)
JoinProject (팀원 모집)
- jp_id (Key2) — int — Primary key — NOT NULL
- board_id (Key) — int — Foreign key → FundingBoardCrew.board_id — NOT NULL
- user_id (Key22) — varchar(30) — Foreign key → User.user_id — NOT NULL
- user_name (Field3) — varchar(30)
- user_email (Field2) — varchar(50)
- subject (Field4) — varchar(255)
- message (Field5) — text
- check_crew (Field6) — int
User (로그인 로그아웃)
- user_id (Key2) — varchar(30) — Primary key — NOT NULL
- user_pw (Field) — varchar(30)
- user_name (Field5) — varchar(30)
- user_email (Field4) — varchar(30)