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