7week cloneCoding

Tables (6)

Entity (User)

  • Key — Primary key — NOT NULL
  • username (email) — string
  • password (Field) — string
  • businessPart (Field2) — string
  • job (string) — string

Entity (BigCategory)

  • big (Key) — Primary key — NOT NULL
  • UserKey (Key2) — Foreign key → Entity.Key — NOT NULL
  • bigcategory (string) — string

Entity (SmallCategory)

  • small (Key2) — Primary key — NOT NULL
  • big (Key) — Foreign key → Entity.big — NOT NULL
  • Key (Key22) — Foreign key → Entity.UserKey — NOT NULL
  • smallcategory (string) — string

Entity (Project)

  • product (Key) — Primary key — NOT NULL
  • Big (Key2) — Foreign key → Entity.small — NOT NULL
  • small (Key3) — Foreign key → Entity.big — NOT NULL
  • UserKey (Key4) — Foreign key → Entity.Key — NOT NULL
  • Key (Key22) — Foreign key → Entity.Key — NOT NULL
  • progressMethod (진행방식) — string
  • projectScope (예산범위) — string
  • title (서비스 제목) — string
  • currentStatus (준비 상황) — string
  • requiredFunction (기본 기능) — string
  • userRelatedFunction (회원 관련 기능) — string
  • commerceRelatedFunction (커머스 관련 기능) — string
  • siteEnvironment (사이트 환경) — string
  • solutionInUse (솔루션 이용 여부) — string
  • reactable (반응형 적용 여부) — string
  • description (의뢰사항) — string
  • budget (프로젝트 예산) — int
  • taxInvoice (세금 계산서 발행 유무) — Boolean
  • volunteerValidDate (지원자 모집 마감 일자) — string
  • dueDateForApplication (프로젝트 작업 마감 일자) — string
  • workingPeriod (작업 기간) — int

Entity (Files)

  • Key4 — Primary key — NOT NULL
  • product (Key) — Foreign key → Entity.product — NOT NULL
  • Big (Key2) — Foreign key → Entity.Big — NOT NULL
  • small (Key3) — Foreign key → Entity.small — NOT NULL
  • Key (Key42) — Foreign key → Entity.UserKey — NOT NULL
  • Key (Key22) — Foreign key → Entity.Key — NOT NULL
  • fileUrl (Field) — string
  • fileName (Field2) — string

Entity (ProfileImages)

  • Key — Primary key — NOT NULL
  • product (Key2) — Foreign key → Entity.product — NOT NULL
  • Big (Key22) — Foreign key → Entity.Big — NOT NULL
  • small (Key3) — Foreign key → Entity.small — NOT NULL
  • Key (Key4) — Foreign key → Entity.UserKey — NOT NULL
  • Key (Key222) — Foreign key → Entity.Key — NOT NULL
  • imageUrl (Field) — string