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