수호테크-erd-capture-260128

테이블 (21)

branch_bom

  • id — bigint
  • branch_type_id — bigint — NOT NULL
  • item_type — varchar(100) — NOT NULL — 품목 구분 / 사출, 가공, 구매 등
  • drawing_number — varchar(100) — NOT NULL — 도번
  • item_name — varchar(255) — NOT NULL — 품명
  • specification — varchar(255) — 규격
  • unit_quantity — bigint — NOT NULL — 단위 수량
  • unit — varchar(30) — 단위 / EA, BOX, ROLL
  • supplied_material — tinyint(1) — NOT NULL — 사급 자재 유무
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

branch_type

  • id — bigint
  • version_id — bigint — NOT NULL
  • code — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • version — date — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL
  • image_url — varchar(255)

material_inbound

  • id — bigint
  • project_id — bigint — NOT NULL
  • drawing_number — varchar(255) — NOT NULL — 도번
  • item_name — varchar(255) — NOT NULL — 품명
  • quantity — bigint — NOT NULL — 입고 수량
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

notification

  • id — bigint
  • content — varchar(50) — NOT NULL
  • url — varchar(100)
  • type — varchar(50) — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

project

  • id — bigint
  • version_id — bigint — NOT NULL
  • region — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • start_date — date
  • end_date — date
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

project_branch

  • id — bigint
  • project_id — bigint — NOT NULL
  • branch_type_id — bigint — NOT NULL
  • total_quantity — bigint — NOT NULL
  • completed_quantity — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

project_branch_history

  • id — bigint
  • change_user_id — bigint — NOT NULL
  • change_user_name — varchar(50) — NOT NULL
  • project_id — bigint — NOT NULL
  • project_branch_id — bigint — NOT NULL
  • branch_type_id — bigint — NOT NULL
  • branch_serial — varchar(50) — NOT NULL
  • action — varchar(50) — NOT NULL
  • before_quantity — bigint — NOT NULL
  • after_quantity — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

project_branch_serial

  • id — bigint
  • serial — varchar(255) — NOT NULL — 시리얼 번호
  • project_branch_id — bigint — NOT NULL
  • state — varchar(50) — NOT NULL
  • production_state — varchar(50) — NOT NULL
  • produced_at — date
  • reason — varchar(50)
  • sequence — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

project_straight

  • id — bigint
  • project_id — bigint — NOT NULL
  • straight_type_id — bigint — NOT NULL
  • straight_info_id — bigint — NOT NULL
  • total_quantity — bigint — NOT NULL
  • completed_quantity — bigint — NOT NULL
  • is_loop_rail — tinyint(1) — NOT NULL
  • length — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

project_straight_history

  • id — bigint
  • change_user_id — bigint — NOT NULL
  • change_user_name — varchar(50) — NOT NULL
  • project_id — bigint — NOT NULL
  • project_straight_id — bigint — NOT NULL
  • straight_serial — varchar(50) — NOT NULL
  • action — varchar(50) — NOT NULL
  • before_quantity — bigint — NOT NULL
  • after_quantity — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

project_straight_serial

  • id — bigint
  • serial — varchar(255) — NOT NULL — 시리얼 번호
  • project_straight_id — bigint — NOT NULL
  • state — varchar(50) — NOT NULL
  • production_state — varchar(50) — NOT NULL
  • produced_at — date
  • reason — varchar(50)
  • sequence — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

straight_info

  • id — bigint
  • hole_position — decimal(5, 1)
  • litzwire1 — decimal(5, 1)
  • litzwire2 — decimal(5, 1)
  • litzwire3 — decimal(5, 1)
  • litzwire4 — decimal(5, 1)
  • litzwire5 — decimal(5, 1)
  • litzwire6 — decimal(5, 1)
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

straight_type

  • id — bigint
  • type — varchar(255) — NOT NULL
  • is_loop_rail — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

user_notification

  • id — bigint
  • user_id — bigint — NOT NULL
  • notification_id — bigint — NOT NULL
  • is_read — tinyint(1) — NOT NULL
  • read_at — datetime
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

users

  • id — bigint — NOT NULL
  • login_id — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • username — varchar(255) — NOT NULL
  • role — varchar(50) — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

version_info

  • id — bigint
  • name — varchar(255) — NOT NULL
  • loop_litz_wire — decimal(4, 1) — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

work_report

  • id — bigint
  • report_user_id — bigint — NOT NULL
  • report_user_name — varchar(50) — NOT NULL
  • project_id — bigint — NOT NULL
  • work_summary — text
  • work_date — date — NOT NULL
  • status — varchar(50) — NOT NULL
  • reject_reason — varchar(50)
  • active_flag — tinyint(1)
  • _utf8mb4APPROVED)) — then
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

work_report_branch

  • id — bigint
  • work_report_id — bigint — NOT NULL
  • project_branch_id — bigint — NOT NULL
  • production_quantity — bigint — NOT NULL
  • snapshot_serial — varchar(50) — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

work_report_branch_serial

  • id — bigint
  • work_report_branch_id — bigint — NOT NULL
  • project_branch_serial_id — bigint — NOT NULL
  • project_branch_serial — varchar(50) — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

work_report_straight

  • id — bigint
  • work_report_id — bigint — NOT NULL
  • project_straight_id — bigint — NOT NULL
  • production_quantity — bigint — NOT NULL
  • snapshot_serial — varchar(50) — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL

work_report_straight_serial

  • id — bigint
  • work_report_straight_id — bigint — NOT NULL
  • project_straight_serial_id — bigint — NOT NULL
  • project_straight_serial — varchar(50) — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL