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)