b3d
Tables (11)
company
- id — UUID
- name — VARCHAR — NOT NULL
- company_type — VARCHAR — NOT NULL
- created_at — TIMESTAMP — NOT NULL
department
- id — UUID
- company_id — UUID — Foreign key → company.id — NOT NULL
- name — VARCHAR — NOT NULL
- sort_order — INT — NOT NULL
menu
- id — UUID
- name — VARCHAR — NOT NULL
- sort_order — INT — NOT NULL
permission
- id — UUID
- role_id — UUID — Foreign key → role.id — NOT NULL
- menu_id — UUID — Foreign key → menu.id — NOT NULL
- can_read — BOOLEAN — NOT NULL
- can_write — BOOLEAN — NOT NULL
- can_edit — BOOLEAN — NOT NULL
- can_delete — BOOLEAN — NOT NULL
position
- id — UUID
- company_id — UUID — Foreign key → company.id — NOT NULL
- name — VARCHAR — NOT NULL
- sort_order — INT — NOT NULL
role
- id — UUID
- company_id — UUID — Foreign key → company.id — NOT NULL
- name — VARCHAR — NOT NULL
user
- id — UUID
- name — VARCHAR — NOT NULL
- email — VARCHAR — NOT NULL
- password — VARCHAR — NOT NULL
- created_at — TIMESTAMP — NOT NULL
user_company
- id — UUID
- user_id — UUID — Foreign key → user.id — NOT NULL
- company_id — UUID — Foreign key → company.id — NOT NULL
- position_id — UUID — Foreign key → position.id
- department_id — UUID — Foreign key → department.id
- role_id — UUID — Foreign key → role.id
- joined_at — TIMESTAMP — NOT NULL
- left_at — TIMESTAMP
user_login
- id — UUID
- user_id — UUID — Foreign key → user.id — NOT NULL
- count — INT — NOT NULL
- locked — BOOLEAN — NOT NULL
- locked_at — TIMESTAMP
- last_try_at — TIMESTAMP
user_private
- id — UUID
- user_id — UUID — Foreign key → user.id — NOT NULL
- phone — VARCHAR
- address — VARCHAR
- account_number — VARCHAR
- registration_number — VARCHAR
user_private_log
- id — UUID
- user_id — UUID — Foreign key → user.id — NOT NULL
- viewer_id — UUID — Foreign key → user.id — NOT NULL
- viewed_at — TIMESTAMP — NOT NULL