First version

Tables (11)

child_menus (child_menu)

  • parent_menu_id (Key) — bigint — Foreign key → menu.menu_id — NOT NULL
  • child_menu_id (Field) — bigint

content

  • content_code (Key) — bigint — 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)

language

  • language_id (Key) — bigint — 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)

login_history (Untitled)

  • history_id (Key) — bigint — Primary key — NOT NULL
  • user_id (userId) — bigint — Foreign key → user.user_id — NOT NULL
  • in_out (Field) — varchar(255)
  • time (Field2) — datetime
  • created_at (Field3) — date
  • created_by (Field4) — varchar(255)
  • modified_at (Field5) — date
  • modified_by (Field6) — varchar(255)

menu

  • menu_id (Key) — bigint — Primary key — NOT NULL
  • menu_name (Field) — 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)

menus_languages (menu_languages)

  • language_id (Key) — bigint — Foreign key → language.language_id — NOT NULL
  • menu_id (Key2) — bigint — Foreign key → menu.menu_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)

menus_permissions (menu_permissions)

  • permission_id (Key2) — bigint — Foreign key → permission.permission_id — NOT NULL
  • menu_id (Key) — bigint — Foreign key → menu.menu_id — NOT NULL
  • read (Field7) — tinyint
  • create (Field6) — tinyint
  • update (Field8) — tinyint
  • delete (Field5) — tinyint
  • created_at (Field) — date
  • created_by (Field2) — varchar(255)
  • modified_at (Field3) — date
  • modified_by (Field4) — varchar(255)

permission (permissions)

  • permission_id (Key) — bigint — 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)

translations

  • content_code (Key) — bigint — Foreign key → content.content_code — NOT NULL
  • language_id (Key2) — bigint — 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)

user

  • user_id (userId) — bigint — Primary key — NOT NULL
  • language_id (Key) — bigint — 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)

users_permissions (user_permissions)

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