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)