study_erd
Tables (14)
Company (Untitled)
- id (ID) — int — Primary key — NOT NULL
- company_id (Company_Id) — int — Primary key — NOT NULL
- personnel (Personnel) — int
DB (Untitled4)
- db_id (DB_ID) — int — Primary key — NOT NULL
- DB — VARCHAR(255)
Employee_Work (emp_work)
- id (社員案件ID) — int — Primary key — NOT NULL
- work_id (案件ID) — int — Foreign key → 案件情報.work_info_id — NOT NULL
- employee_id (社員ID) — int — Foreign key → 従業員情報.id — NOT NULL
- assignment (Assignment) — DATE
- finish (Finish) — DATE
Employee_skill (emp_skill)
- id (ID) — int — Primary key — NOT NULL
- skill_id (Skill_ID) — int — Foreign key → Skill.id — NOT NULL
- emp_id (Emp_ID) — int — Foreign key → 従業員情報.id — NOT NULL
OS (Untitled2)
- os_id (OS_ID) — int — Primary key — NOT NULL
- os (OS) — VARCHAR(255)
Skill (skill)
- id (ID) — int — Primary key — NOT NULL
- skill (Skill) — VARCHAR(255)
- get_date (Field) — VARCHAR(255)
Skillset (Untitled3)
- skillset_id (スキルセットID) — int — Primary key — NOT NULL
- work_info_id (Work_Info_ID) — int — Foreign key → 案件情報.work_info_id — NOT NULL
- language_id (開発言語ID) — int — Foreign key → 開発言語.language_id — NOT NULL
- os_id (OS_ID) — int — Foreign key → OS.os_id — NOT NULL
- db_id (DB_ID) — int — Foreign key → DB.db_id — NOT NULL
- development_id (開発環境ID) — int — Foreign key → 開発環境.development_id — NOT NULL
役職 (Yakusyoku)
- id (ID) — int — Primary key — NOT NULL
- work_info_id (案件情報ID) — int — Foreign key → 案件情報.work_info_id — NOT NULL
- name (役職名) — VARCHAR(255)
従業員情報 (emp_info)
- id (ID) — int — Primary key — NOT NULL
- company_id (Company_Id) — int — Foreign key → Company.company_id — NOT NULL
- emp_num (Emp_Num) — int
- name (Name) — VARCHAR(255)
- furigana (Furigana) — VARCHAR(255)
- birthday (BirthDay) — VARCHAR(255)
- sex (Sex) — VARCHAR(255)
- date_of_employyment (Date_Of_Employment) — VARCHAR(255)
担当作業 (position)
- sagyou_ID (担当作業ID) — int — Primary key — NOT NULL
- position (Position) — VARCHAR(255)
案件ポジション (Untitled7)
- work_position_id (案件ポジションID) — int — Primary key — NOT NULL
- sagyou_ID (担当作業ID) — int — Foreign key → 担当作業.sagyou_ID — NOT NULL
- id (社員案件ID) — int — Foreign key → Employee_Work.id — NOT NULL
案件情報 (work_info)
- work_info_id (案件情報ID) — int — Primary key — NOT NULL
- project_name (Project_Name) — VARCHAR(255)
- members (Members) — int
- start (Start) — VARCHAR(255)
- end (End) — VARCHAR(255)
- span (Span) — VARCHAR(255)
- commodity (Commodity) — VARCHAR(255)
- work_form (Work_Form) — VARCHAR(255)
開発環境 (Untitled6)
- development_id (開発環境ID) — int — Primary key — NOT NULL
- tool (Tool) — VARCHAR(255)
- cpu (CPU名) — VARCHAR(255)
開発言語 (Untitled5)
- language_id (開発言語ID) — int — Primary key — NOT NULL
- language (Language) — VARCHAR(255)