DB_Project

Tables (10)

APPLY (Untitled11)

  • FREELANCER_ID (Key) — Foreign key → FREE_LANCER.FREELANCER_ID — NOT NULL
  • REQUEST_NAME (Key2) — Foreign key → REQUEST.REQUEST_NAME — NOT NULL

CLIENT (Untitled5)

  • CLIENT_ID (Key) — Primary key — NOT NULL
  • PW (Field)
  • CNAME (Field2)
  • PHONE_NUMBER (Field3)
  • GRADE (Field4)

FREE_LANCER (Untitled2)

  • FREELANCER_ID (Key) — Primary key — NOT NULL
  • PW (Field)
  • FNAME (Field2)
  • AGE (Field3)
  • DEV_CAREER (Field4)
  • MAJOR (Field5)
  • PHONE_NUMBER (Field6)
  • GRADE (Field7)

LANGUAGE_COMPETENCE (Untitled3)

  • FREELANCER_ID (Key) — Foreign key → FREE_LANCER.FREELANCER_ID — NOT NULL
  • F_LANGUAGE (Field)
  • F_COMPETENCE (Field2)

PORTFOLIO (Untitled4)

  • FREELANCER_ID (Key) — Foreign key → FREE_LANCER.FREELANCER_ID — NOT NULL
  • INTERNEL (Field)
  • INTERNEL_POINT (Field2)
  • EXTERNEL (Field3)

REQUEST (Untitled6)

  • REQUEST_NAME (Key2) — Primary key — NOT NULL
  • CLIENT_ID (Key) — Foreign key → CLIENT.CLIENT_ID — NOT NULL
  • FREELANCER_ID (Key3) — Foreign key → FREE_LANCER.FREELANCER_ID — NOT NULL
  • DEV_START_DATE (Field2)
  • DEV_END_DATE (Field3)
  • REQUEST_DATE (Field4)
  • LANGUAGE (Field5)
  • MINIMUN_CAREER (Field7)
  • MIN_NUM_FREELANCER (Field8)
  • MAX_NUM_FREELANCER (Field)
  • REJECT (Field6)
  • APPLY_FINISH (Field9)

REQUEST_DOCUMENT (Untitled9)

  • REQUEST_NAME (Key2) — Foreign key → REQUEST.REQUEST_NAME — NOT NULL
  • REQUEST_DOC (Field)

REQUEST_LANGUAGE (Untitled8)

  • REQUEST_NAME (Key2) — Foreign key → REQUEST.REQUEST_NAME — NOT NULL
  • R_LANGUAGE (Field2)
  • R_COMPETENCE (Field3)

TEAM_INFO (Untitled)

  • TNAME (Key2) — Primary key — NOT NULL
  • FREELANCER_ID (Key) — Foreign key → FREE_LANCER.FREELANCER_ID — NOT NULL
  • TEAM_LEADER_ID (Field)

WORKS_ON (Untitled10)

  • FREE_LANCER_ID (Key) — Foreign key → FREE_LANCER.FREELANCER_ID — NOT NULL
  • REQUEST_NAME (Key2) — Foreign key → REQUEST.REQUEST_NAME — NOT NULL
  • CLIENT_ID (Key3) — Foreign key → REQUEST.FREELANCER_ID — NOT NULL
  • FINISH_INFO (Field3)