S13P31A407

Tables (12)

attendance (Untitled10)

  • word_date (Key2) — DATE — Primary key — NOT NULL
  • user_account_id (Key3) — BIGINT — Foreign key → user_accounts.id — NOT NULL
  • check_in_time (Field2) — DATETIME
  • check_out_time (Field) — DATETIME
  • total_word_minutes (Field3) — INT

companies (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • created_at (Field2) — DATETIME
  • updated_at (Field3) — DATETIME

company_equipments (Untitled6)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • company_id (Key2) — BIGINT — Foreign key → companies.id — NOT NULL
  • equipment_id (Key3) — BIGINT — Foreign key → equipments.id — NOT NULL
  • name (Field) — VARCHAR(255)
  • deleted (Field2) — DATETIME
  • created_at (Field3) — DATETIME
  • updated_at (Field4) — DATETIME

company_uuid (Untitled8)

  • company_id (Key) — BIGINT — Foreign key → companies.id — NOT NULL
  • uuid (Field2) — VARCHAR(36)
  • expired_at (Field3) — DATETIME

equipment_categories (Untitled11)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • created_at (Field2) — DATETIME
  • updated_at (Field3) — DATETIME

equipment_faq (Untitled7)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • equipment_id (Key2) — BIGINT — Foreign key → equipments.id — NOT NULL
  • question (Field) — TEXT
  • answer (Field2) — TEXT
  • created_at (Field3) — DATETIME
  • updated_at (Field4) — DATETIME

equipments (Untitled5)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • equipment_categorie_id (Key2) — BIGINT — Foreign key → equipment_categories.id — NOT NULL
  • name (Field) — VARCHAR(255)
  • image (Field2) — VARCHAR(255)
  • created_at (Field3) — DATETIME
  • updated_at (Field4) — DATETIME

refresh_token (Untitled9)

  • user_account_id (Key) — BIGINT — Foreign key → user_accounts.id — NOT NULL
  • refresh_token (Field) — VARCHAR(255)
  • expired_at (Field2) — DATETIME

roles (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • role (Field) — VARCHAR(10)
  • created_at (Field2) — DATETIME
  • updated_at (Field3) — DATETIME

tasks (Untitled13)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • company_id (Key2) — BIGINT — Foreign key → companies.id — NOT NULL
  • equipment_id (Key3) — BIGINT — Foreign key → equipments.id — NOT NULL
  • user_account_id (Key4) — BIGINT — Foreign key → user_accounts.id — NOT NULL
  • request (Field2) — TEXT
  • action (Field3) — INT
  • solution (Field) — TEXT
  • created_at (Field4) — DATETIME
  • updated_at (Field5) — DATETIME

user_accounts (Untitled4)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key3) — BIGINT — Foreign key → users.id — NOT NULL
  • company_id (Key2) — BIGINT — Foreign key → companies.id — NOT NULL
  • equipment_id (Key5) — BIGINT — Foreign key → equipments.id — NOT NULL
  • email (Field3) — VARCHAR(100)
  • password (Field4) — VARCHAR(255)
  • role_id (Key4) — BIGINT — Foreign key → roles.id — NOT NULL
  • online (Field6) — TINYINT
  • ban (Field7) — TINYINT
  • exit (Field8) — DATETIME
  • created_at (Field9) — DATETIME
  • updated_at (Field10) — DATETIME

users (Untitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(30)
  • birth (Field2) — DATE
  • phone (Field3) — VARCHAR(11)
  • created_at (Field4) — DATETIME
  • updated_at (Field5) — DATETIME