Resume
Tables (5)
Company (회사)
- UserID (Key2) — varchar2 — Primary key — NOT NULL
- UserPw (Field) — varchar2
- CompanyName (Field9) — varchar2
- Address (Field3) — varchar2
- ManagerName (Field4) — varchar2
- ManagerEmail (Field5) — varchar2
- ManagerPhoneFristNum (Field6) — Number
- BusinessNum (key) — Number
Company introduction (회사소개)
- UserID (Key2) — varchar2 — Foreign key → Company.UserID — NOT NULL
- Content (Field) — varchar2
- HireNum (Field2) — Number
- Salary (Field3) — varchar2
- Welfare (Field4) — varchar2
- CompanyName (Key) — varchar2 — NOT NULL
Portfolio (포트폴리오)
- CodeNum (Key2) — Number — Primary key — NOT NULL
- Title (Key) — NOT NULL
- Content (Field)
- Photo (Field2)
- Function (Field3)
- UserID (Key3) — varchar2 — Foreign key → User.UserID — NOT NULL
Resume (이력서)
- UserNmae (Key) — varchar2 — Primary key — NOT NULL
- UserID (Key2) — varchar2 — Foreign key → User.UserID — NOT NULL
- Title (Field5) — varchar2
- Content (Field) — varchar2
- Photo (Field2) — File
- HopeSalary (Field3) — varchar2
- HopeWelfare (Field4) — varchar2
User (구직자)
- UserID (Key) — varchar2 — Primary key — NOT NULL
- UserPw (Field) — varchar2
- UserName (Field9) — varchar2
- Email (Field3) — varchar2
- PhoneNum (Field4) — Number
- Gender (Field5) — varchar2