temp
Tables (15)
ASSET
- asset_id — Number — Primary key — NOT NULL
- asset_version — String
- asset_name — String
- asset_user_guide — String
Department-Asset
- department_asset_id — Number — Primary key — NOT NULL
- asset_id — Number — NOT NULL
- department_id — Number — NOT NULL
Manage
- manger_id — Number — Primary key — NOT NULL
- user_id — Number — NOT NULL
- asset_id — Number — NOT NULL
Request
- request_id — Number — Primary key — NOT NULL
- user_id — Number — NOT NULL
- asset_id — Number — NOT NULL
- request_reason — Varchar(50)
- access_date — DATE
- requet_start_date — DATE
- request_finish_date — DATE
Request-Mange
- manger_id — Number — Foreign key → Manage.manger_id — NOT NULL
- request_id — Number — Foreign key → Request.request_id — NOT NULL
- request_date — Date
- request_status_update_date — Date
RequestLog
- request_log_id — Number — Primary key — NOT NULL
- request_id — Number — NOT NULL
- request_log_status — varchar(10)
- request_update_date — Date
RequestMangeLog
- request_log_id — Number — Primary key — NOT NULL
- request_status — String
- request_update_date — Date
- manger_id — Number — NOT NULL
- request_id — Number — NOT NULL
SupplyType
- asset_id — Number — Foreign key → ASSET.asset_id — NOT NULL
- install_file_url — String
- access_url — String
- install_guide — String
Untitled
- Key — Number — Primary key — NOT NULL
- Field — String
Untitled2
- user_request_info_id — Number — Primary key — NOT NULL
- request_id — Number — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
User
- user_id — Number — Primary key — NOT NULL
- user_name — String
- Field2 — String
- user_photo — String
- user_contact — String
- Key — Number — NOT NULL
- department_id — Number — NOT NULL
UserStatus
- user_log_id — Number — Primary key — NOT NULL
- user_id — Number — NOT NULL
- Field — String
department
- department_id — Number — Primary key — NOT NULL
- department_name — String
- Key — Number — NOT NULL
number
- asset_id — Number — Foreign key → ASSET.asset_id — NOT NULL
- max_users_limit — Number
- max_cpu_limit — Number
- range_ip — String
- curr_users — Number
- curr_cpu — Number
period
- asset_id — Number — Foreign key → ASSET.asset_id — NOT NULL
- start_date — DATE
- finish_date — DATE