| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
Comments |
| WorkExperienceSeq |
int identity |
4 |
|
√ |
null |
|
|
|
| ID |
int |
4 |
|
|
null |
|
|
|
| EmployerID |
int |
4 |
|
|
((0)) |
|
|
|
| EmployerContact |
varchar |
60 |
|
|
('') |
|
|
|
| EmployerSupervisor |
varchar |
60 |
|
|
('') |
|
|
|
| DateStart |
datetime |
16,3 |
√ |
|
null |
|
|
|
| DateFinish |
datetime |
16,3 |
√ |
|
null |
|
|
|
| TimeFrom |
varchar |
10 |
|
|
('') |
|
|
|
| TimeTo |
varchar |
10 |
|
|
('') |
|
|
|
| PayRate |
varchar |
10 |
|
|
('') |
|
|
|
| OccupType |
varchar |
15 |
|
|
('') |
|
|
|
| StaffID |
int |
4 |
|
|
((0)) |
|
|
|
|
varchar |
255 |
√ |
|
('') |
|
|
|
Table contained -1 rows
| Constraint Name |
Type |
Sort |
Column(s) |
| PK_WorkExperience |
Primary key |
Asc |
WorkExperienceSeq |
| AK_WorkExperience_ID |
Performance |
Asc |
ID |