sub1
Tables (3)
positions
- id (pk) — not null — Primary key — NOT NULL
- title (Field) — not null
- usable (Field5) — default 'Y'
- created_at (Field2) — now()
- updated_at (Field3) — now()
- deleted_at (Field4) — now()
user_groups
- id (pk) — not null — Primary key — NOT NULL
- title (Field) — not null
- created_at (Field2) — now()
- updated_at (Field3) — now()
- deleted_at (Field4)
users
- id (pk) — not null — Primary key — NOT NULL
- name (Field) — not null
- mphone (Field5) — not null
- created_at (Field2) — now()
- updated_at (Field3) — now()
- deleted_at (Field4)
- user_group_id (fk) — not null — Foreign key → user_groups.id — NOT NULL
- id (pk2) — not null — Foreign key → positions.id — NOT NULL