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