hau

Tables (16)

Copy Of データベース (CopyOfDatabase)

  • Database id (database_id) — INT — Primary key — NOT NULL
  • Database name (database_name) — NCHAR(255)

OS

  • OS id (os_id) — INT — Primary key — NOT NULL
  • OS name (os_name) — NCHAR(255)

データベース (Database)

  • Database id (database_id) — INT — Primary key — NOT NULL
  • Database name (database_name) — NCHAR(255)

プロジェクト (Project)

  • Project id (project_id) — INT — Primary key — NOT NULL
  • OS id (os_id) — INT — Foreign key → OS.OS id — NOT NULL
  • Database id (database_id) — INT — Foreign key → データベース.Database id — NOT NULL
  • Project Name (project_name) — NCHAR(255)
  • Work content (work_content) — NTEXT
  • Form (form) — INT

プロジェクト作業 (Project Work)

  • Project Work Id (project_work_id) — INT — Primary key — NOT NULL
  • Work id (work_id) — INT — Foreign key → 作業.Work id — NOT NULL
  • Project id (project_id) — INT — Foreign key → プロジェクト.Project id — NOT NULL

プロジェクト役割 (Project_Position)

  • Project Position Id (pj_pos_id) — INT — Primary key — NOT NULL
  • Project id (project_id) — INT — Foreign key → プロジェクト.Project id — NOT NULL
  • Position id (position_id) — INT — Foreign key → 役割.Position id — NOT NULL
  • Employee_id (employee_id) — INT — Foreign key → 社員.Employee_id — NOT NULL

プロジェクト環境ツール (PJ_Env_Tool)

  • PJ_Env_Tool ID (pj_env_tool_id) — INT — Primary key — NOT NULL
  • Env_tool ID (env_tool_id) — INT — Foreign key → 環境 ツール.Env_tool ID — NOT NULL
  • Project id (project_id) — INT — Foreign key → プロジェクト.Project id — NOT NULL

プロジェクト言語 (Project_Deve_Lang)

  • Project_Deve_Lang ID (project_deve_lang_id) — INT — Primary key — NOT NULL
  • Deve _lang id (deve_lang_id) — INT — Foreign key → 開発言語.Deve _lang id — NOT NULL
  • Project id (project_id) — INT — Foreign key → プロジェクト.Project id — NOT NULL

作業 (Work)

  • Work id (work_id) — INT — Primary key — NOT NULL
  • Work Name (work_name) — NCHAR(255)

役割 (Position)

  • Position id (position_id) — INT — Primary key — NOT NULL
  • Position name (position_name) — NCHAR(255)

環境 ツール (Env_Tool)

  • Env_tool ID (env_tool_id) — INT — Primary key — NOT NULL
  • Env_tool Name (env_tool_name) — NCHAR(255)

社員 (Employees)

  • Employee_id (employee_id) — INT — Primary key — NOT NULL
  • Employee Name (employee_name) — NCHAR(225)
  • Birthday (birthday) — DATE
  • Gender (gender) — INT
  • Joining date (joining_date) — DATE
  • Furigana (furigana) — NCHAR(255)
  • Nearest Station (nearest_station) — NCHAR(255)

社員作業 (Employee Work)

  • Employee Work Id (employee_work_id) — INT — Primary key — NOT NULL
  • Project Work Id (project_work_id) — INT — Foreign key → プロジェクト作業.Project Work Id — NOT NULL
  • Employee_id (employee_id) — INT — Foreign key → 社員.Employee_id — NOT NULL

社員資格 (Empl_Qualificat)

  • Empl_Qualificat ID (empl_qualificat_id) — INT — Primary key — NOT NULL
  • Employee_id (employee_id) — INT — Foreign key → 社員.Employee_id — NOT NULL
  • Qualification id (qualification_id) — INT — Foreign key → 資格.Qualification id — NOT NULL

資格 (Qualification)

  • Qualification id (qualification_id) — INT — Primary key — NOT NULL
  • Qualification Name (qualification_name) — NCHAR(225)

開発言語 (Deve_Lang)

  • Deve _lang id (deve_lang_id) — INT — Primary key — NOT NULL
  • Deve Lang Name (deve_lang_name) — NCHAR(255)