asdsa

Tables (10)

COMPANY

  • company_id — INT
  • company_name — VARCHAR(100) — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL
  • address — VARCHAR(255)
  • contact_info — VARCHAR(100)
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_active — BOOLEAN

COMPANY_PROGRAM

  • company_program_id — INT
  • company_id — INT — NOT NULL
  • program_id — INT — NOT NULL
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME
  • is_active — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

MENU

  • menu_id — INT
  • parent_menu_id — INT
  • menu_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • display_order — INT
  • icon — VARCHAR(50)
  • program_id — INT
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_active — BOOLEAN

PERMISSION

  • permission_id — INT
  • permission_code — VARCHAR(50) — NOT NULL
  • permission_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

PROGRAM

  • program_id — INT
  • program_code — VARCHAR(50) — NOT NULL
  • program_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • version — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_active — BOOLEAN

PROGRAM_PERMISSION

  • program_permission_id — INT
  • program_id — INT — NOT NULL
  • permission_id — INT — NOT NULL
  • created_at — DATETIME

ROLE

  • role_id — INT
  • company_id — INT — NOT NULL
  • role_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

ROLE_PERMISSION

  • role_permission_id — INT
  • role_id — INT — NOT NULL
  • permission_id — INT — NOT NULL
  • program_id — INT — NOT NULL
  • created_at — DATETIME

USER

  • user_id — INT
  • company_id — INT — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • full_name — VARCHAR(100) — NOT NULL
  • position — VARCHAR(50)
  • department — VARCHAR(50)
  • last_login — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_active — BOOLEAN

USER_ROLE

  • user_role_id — INT
  • user_id — INT — NOT NULL
  • role_id — INT — NOT NULL
  • created_at — DATETIME