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