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