ispemosdb
Tables (7)
capaian
- id — Primary key — NOT NULL
- keterangan — NOT NULL
- status — NOT NULL — 1-aktif 2-tidak aktif
menu
- id — Primary key — NOT NULL
- roles_id — Foreign key → roles.id — NOT NULL
- capaian_id — Foreign key → capaian.id — NOT NULL
- menu_id — id untuk parent menu
- keterangan — NOT NULL
- status — NOT NULL — 1-aktif 2-tidak aktif
- url — NOT NULL — url skrin
- jujukan — NOT NULL
profile
- id — Primary key — NOT NULL
- keterangan — NOT NULL
roles
- id — Primary key — NOT NULL
- keterangan — NOT NULL
- status — NOT NULL — 1-aktif 2-tidak aktif
roles_has_capaian
- id — Primary key — NOT NULL
- roles_id — Foreign key → roles.id — NOT NULL
- capaian_id — Foreign key → capaian.id — NOT NULL
- keterangan — NOT NULL
user
- id — Primary key — NOT NULL
- profile_id — Foreign key → profile.id — NOT NULL
- keterangan — NOT NULL
- status — NOT NULL — 1-aktif 2-tidak aktif
user_has_permission
- id — Primary key — NOT NULL
- user_id — Foreign key → user.id — NOT NULL
- roles_id — Foreign key → roles.id — NOT NULL
- capaian_id — Foreign key → capaian.id — NOT NULL
- keterangan — NOT NULL