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