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)