수호테크-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