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