Fergus
Tables (7)
Company (company)
- Key (company_id) — GUID — Primary key — NOT NULL
- Name (name) — varchar
- Creation Date (created_at) — datetime
- Updated Date (updated_at) — datetime
Job (job)
- Key (job_id) — GUID — Primary key — NOT NULL
- Key (company_id) — GUID — Foreign key → Company.Key — NOT NULL
- Key (job_status_id) — GUID — Foreign key → Job Status.Key — NOT NULL
- Creation Date (created_at) — datetime
- Updated Date (updated_at) — datetime
Job Status (job_status)
- Key (job_status_id) — GUID — Primary key — NOT NULL
- Order (order) — int
- Name (name) — varchar
- Creation Date (created_at) — datetime
- Updated Date (updated_at) — datetime
Note (note)
- Key (note_id) — GUID — Primary key — NOT NULL
- Key (job_id) — GUID — Foreign key → Job.Key — NOT NULL
- Key (user_id) — GUID — Foreign key → User.Key — NOT NULL
- Content (body) — varchar
- Created Date (created_at) — datetime
- Updated Date (updated_at) — datetime
Role (role)
- Key (role_id) — GUID — Primary key — NOT NULL
- Key (company_id) — GUID — Foreign key → Company.Key — NOT NULL
- Key (user_id) — GUID — Foreign key → User.Key — NOT NULL
- Key (role_type_id) — GUID — Foreign key → Role Type.Key — NOT NULL
- Created Date (created_at) — datetime
- Updated Date (updated_at) — datetime
Role Type (role_type)
- Key (role_type_id) — GUID — Primary key — NOT NULL
- Created Date (created_at) — datetime
- Updated Date (updated_at) — datetime
- Name (name) — varchar
- Level (level) — int
User (user)
- Key (user_id) — GUID — Primary key — NOT NULL
- Name (name) — varchar
- Created Date (created_at) — datetime
- Updated Date (updated_at) — datetime
- Contact (contact) — varchar
- Field