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)