Sistem Informasi Penerimaan Calon Asisten Laboratorium Terpadu (Mode Lite)

Tables (4)

RegistrasiUsers (Untitled)

  • RegistrasiId (Key) — INT(11) — Primary key — NOT NULL
  • UserAccountId (user_id2) — INT(11) — Foreign key → UserAccounts.UserAccountId — NOT NULL
  • Nama (Field) — varchar(50)
  • Stambuk (Field2) — VARCHAR(50)
  • ContactNo (Field4) — VARCHAR(13)
  • Foto (Field5) — VARCHAR(50)

Roles (Untitled2)

  • RoleId (Key) — INT(11) — Primary key — NOT NULL
  • Field — INT(11)

UserAccounts (users)

  • UserAccountId (user_id) — INT(11) — Primary key — NOT NULL
  • Usernam (nama) — varchar(50)
  • Email (Field) — varchar(50)
  • Password (Field2) — varchar(50)

UserRoles (Untitled3)

  • RoleId (Key) — INT(11) — Foreign key → Roles.RoleId — NOT NULL
  • UserAccountId (user_id) — INT(11) — Foreign key → UserAccounts.UserAccountId — NOT NULL