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)