obigoBO-ERD

Tables (9)

User_Permissions (Untitled5)

  • permission id (Key) — int — Foreign key → permissions.permission_id — NOT NULL
  • user_id (userId) — int — Foreign key → user.user_id — NOT NULL
  • created_at (Field) — date
  • created_by (Field2) — varchar(255)
  • modified_at (Field3) — date
  • modified_by (Field4) — varchar(255)

content_codes (Untitled6)

  • content_id (Key) — int — Primary key — NOT NULL
  • content_name (Field) — varchar(255)
  • created_at (Field3) — date
  • created_by (Field4) — varchar(255)
  • modified_at (Field5) — date
  • modified_by (Field6) — varchar(255)

content_language (Untitled9)

  • content_id (Key) — int — Foreign key → content_codes.content_id — NOT NULL
  • language_id (Key2) — int — Foreign key → language.language_id — NOT NULL
  • text (Field) — varchar(1000)
  • created_at (Field2) — date
  • created_by (Field3) — varchar(255)
  • modified_at (Field4) — date
  • modified_by (Field5) — varchar(255)

language (Untitled8)

  • language_id (Key) — int — Primary key — NOT NULL
  • language_name (Field) — varchar(255)
  • created_at (Field2) — date
  • created_by (Field3) — varchar(255)
  • modified_at (Field4) — date
  • modified_by (Field5) — varchar(255)

menu_codes (Untitled2)

  • menu_id (Key) — int — Primary key — NOT NULL
  • child_menu_id (Key2) — int — Foreign key → menu_codes.menu_id — NOT NULL
  • menu_name (Field) — varchar(255)
  • icon (Field2) — varchar(255)
  • url (Field3) — varchar(255)
  • depth (Field8) — int
  • order (Field10) — int
  • created_at (Field4) — date
  • created_by (Field5) — varchar(255)
  • modified_at (Field6) — date
  • modified_by (Field7) — varchar(255)

menu_language (Untitled3)

  • menu_id (Key2) — int — Foreign key → menu_codes.menu_id — NOT NULL
  • language_id (Key) — int — Foreign key → language.language_id — NOT NULL
  • text (Field) — varchar(1000)
  • created_at (Field2) — date
  • created_by (Field3) — varchar(255)
  • modified_at (Field4) — date
  • modified_by (Field5) — varchar(255)

menu_permissions (Untitled7)

  • permission_id (Key2) — int — Foreign key → permissions.permission_id — NOT NULL
  • menu_id (Key) — int — Foreign key → menu_codes.menu_id — NOT NULL
  • created_at (Field) — date
  • created_by (Field2) — varchar(255)
  • modified_at (Field3) — date
  • modified_by (Field4) — varchar(255)

permissions (Untitled4)

  • permission_id (Key) — int — Primary key — NOT NULL
  • permission_name (Field) — varchar(255)
  • created_at (Field2) — date
  • created_by (Field3) — varchar(255)
  • modified_at (Field4) — date
  • modified_at (Field5) — varchar(255)

user (Untitled)

  • user_id (userId) — int — Primary key — NOT NULL
  • language_id (Key) — int — Foreign key → language.language_id — NOT NULL
  • first_name (firstName) — varchar(255) — NOT NULL
  • last_name (lastName) — varchar(255)
  • email — varchar(255)
  • password — varchar(255)
  • username — varchar(255)
  • login_attempts (loginAttempts) — int
  • is_locked (Field) — boolean
  • created_at (Field2) — date
  • created_by (Field3) — varchar(255)
  • modified_at (Field4) — date
  • modified_by (Field5) — varchar(255)