ERD

Tables (36)

activity

  • activity_id — VARCHAR(20) — 활동ID (ACT-NNN)
  • client_id — VARCHAR(20) — Foreign key → client.client_id — NOT NULL — 거래처ID
  • po_header_id — VARCHAR(20) — Foreign key → po_header.po_header_id — PO헤더ID
  • type — VARCHAR(20) — NOT NULL — 유형 (meeting/note/issue/comment/schedule)
  • title — VARCHAR(200) — NOT NULL — 제목
  • content — TEXT — 내용
  • activity_date — DATE — NOT NULL — 활동일
  • author_id — BIGINT — Foreign key → user_account.user_account_id — NOT NULL — 작성자ID
  • priority — VARCHAR(20) — 우선순위 (high/medium/low)
  • resolved — BOOLEAN — 해결여부
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

activity_attachment

  • activity_attachment_id — BIGINT — 활동첨부파일ID
  • activity_id — VARCHAR(20) — Foreign key → activity.activity_id — NOT NULL — 활동ID
  • file_name — VARCHAR(300) — NOT NULL — 파일명
  • file_path — VARCHAR(500) — 파일경로
  • file_size — BIGINT — 파일크기 (bytes)
  • created_at — DATETIME — NOT NULL — 생성일시

activity_package

  • activity_package_id — VARCHAR(20) — 활동패키지ID (PKG-NNN)
  • client_id — VARCHAR(20) — Foreign key → client.client_id — NOT NULL — 거래처ID
  • generated_by_id — BIGINT — Foreign key → user_account.user_account_id — NOT NULL — 생성자ID
  • period_start — DATE — 취합 시작일
  • period_end — DATE — 취합 종료일
  • include_types — VARCHAR(200) — 포함 유형
  • status — VARCHAR(20) — NOT NULL — 상태 (GENERATING/COMPLETED/FAILED)
  • file_path — VARCHAR(500) — PDF 파일경로
  • created_at — DATETIME — NOT NULL — 생성일시

buyer

  • buyer_id — VARCHAR(20) — 바이어담당자ID (BY-XXX)
  • client_id — VARCHAR(20) — Foreign key → client.client_id — NOT NULL — 거래처ID
  • name — VARCHAR(100) — NOT NULL — 담당자명
  • position — VARCHAR(100) — 직책
  • email — VARCHAR(100) — 이메일
  • phone — VARCHAR(50) — 전화번호
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

ci_header

  • ci_header_id — VARCHAR(20) — CI헤더ID (CI-YYYY-NNN)
  • po_header_id — VARCHAR(20) — Foreign key → po_header.po_header_id — NOT NULL — PO헤더ID
  • shipment_order_id — VARCHAR(20) — Foreign key → shipment_order.shipment_order_id — 출하지시서ID
  • client_id — VARCHAR(20) — Foreign key → client.client_id — NOT NULL — 거래처ID
  • invoice_no — VARCHAR(50) — NOT NULL — 송장번호
  • invoice_date — DATE — NOT NULL — 송장일자
  • currency_id — VARCHAR(10) — Foreign key → currency.currency_id — NOT NULL — 통화
  • incoterms — VARCHAR(50) — 인코텀즈
  • payment_terms — VARCHAR(50) — 결제조건
  • total_amount — DECIMAL(18, 2) — NOT NULL — 총금액
  • port_of_loading — VARCHAR(100) — 선적항
  • port_of_discharge — VARCHAR(100) — 도착항
  • carrier — VARCHAR(100) — 운송사
  • sailing_date — DATE — 출항일
  • country_of_origin — VARCHAR(100) — 원산지
  • manager_id — BIGINT — Foreign key → user_account.user_account_id — 담당자ID
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

ci_item

  • ci_item_id — BIGINT — CI품목ID
  • ci_header_id — VARCHAR(20) — Foreign key → ci_header.ci_header_id — NOT NULL — CI헤더ID
  • product_id — VARCHAR(20) — Foreign key → product.product_id — 품목ID
  • description — VARCHAR(300) — NOT NULL — 품목 설명
  • qty — INT — NOT NULL — 수량
  • unit — VARCHAR(20) — NOT NULL — 단위
  • unit_price — DECIMAL(18, 4) — NOT NULL — 단가
  • amount — DECIMAL(18, 2) — NOT NULL — 금액
  • sort_order — INT — NOT NULL — 정렬순서

client

  • client_id — VARCHAR(20) — 거래처ID (CL-XXX)
  • name — VARCHAR(200) — NOT NULL — 영문 상호
  • name_kr — VARCHAR(200) — 한글 상호
  • country_id — BIGINT — Foreign key → country.country_id — 국가ID
  • city — VARCHAR(100) — 도시
  • address_kr — VARCHAR(500) — 한글 주소
  • address_en — VARCHAR(500) — 영문 주소
  • biz_no — VARCHAR(50) — 사업자번호
  • tel — VARCHAR(50) — 전화번호
  • email — VARCHAR(100) — 이메일
  • payment_terms — VARCHAR(50) — 결제조건
  • incoterms — VARCHAR(50) — 인코텀즈
  • currency_id — VARCHAR(10) — Foreign key → currency.currency_id — 기본 거래통화
  • port_id — BIGINT — Foreign key → port.port_id — 기본 도착항ID
  • tax_yn — CHAR(1) — NOT NULL — 과세여부
  • manager_id — BIGINT — Foreign key → user_account.user_account_id — 담당자ID
  • stamp_image_url — VARCHAR(500) — 도장 이미지 URL
  • signature_image_url — VARCHAR(500) — 서명 이미지 URL
  • status — VARCHAR(20) — NOT NULL — 상태
  • reg_date — DATE — 등록일
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

collection

  • collection_id — VARCHAR(20) — 수금ID (COL-NNN)
  • po_header_id — VARCHAR(20) — Foreign key → po_header.po_header_id — NOT NULL — PO헤더ID
  • ci_header_id — VARCHAR(20) — Foreign key → ci_header.ci_header_id — CI헤더ID
  • client_id — VARCHAR(20) — Foreign key → client.client_id — NOT NULL — 거래처ID
  • total_amount — DECIMAL(18, 2) — NOT NULL — 총금액
  • collected_amount — DECIMAL(18, 2) — NOT NULL — 수금액
  • balance — DECIMAL(18, 2) — NOT NULL — 잔액
  • currency_id — VARCHAR(10) — Foreign key → currency.currency_id — NOT NULL — 통화
  • status — VARCHAR(20) — NOT NULL — 상태 (PAID/PARTIAL/UNPAID)
  • due_date — DATE — 수금예정일
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

collection_history

  • collection_history_id — BIGINT — 수금이력ID
  • collection_id — VARCHAR(20) — Foreign key → collection.collection_id — NOT NULL — 수금ID
  • payment_date — DATE — NOT NULL — 입금일
  • amount — DECIMAL(18, 2) — NOT NULL — 입금액
  • method — VARCHAR(50) — NOT NULL — 결제방법 (T/T/L/C)
  • note — VARCHAR(500) — 비고
  • created_at — DATETIME — NOT NULL — 생성일시

company

  • company_id — BIGINT — 자사ID
  • name — VARCHAR(200) — NOT NULL — 영문 상호
  • name_kr — VARCHAR(200) — 한글 상호
  • address — VARCHAR(500) — 주소
  • tel — VARCHAR(50) — 전화번호
  • fax — VARCHAR(50) — 팩스
  • email — VARCHAR(100) — 이메일
  • stamp_image_url — VARCHAR(500) — 도장 이미지 URL
  • signature_image_url — VARCHAR(500) — 서명 이미지 URL
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

country

  • country_id — BIGINT — 국가ID
  • code — VARCHAR(5) — NOT NULL — ISO 국가코드
  • name — VARCHAR(100) — NOT NULL — 국가명
  • currency_id — VARCHAR(10) — Foreign key → currency.currency_id — NOT NULL — 기본 통화코드
  • created_at — DATETIME — NOT NULL — 생성일시

currency

  • currency_id — VARCHAR(10) — 통화코드 (USD/EUR/JPY)
  • name — VARCHAR(50) — 통화명
  • created_at — DATETIME — NOT NULL — 생성일시

dept_transfer_history

  • dept_transfer_history_id — BIGINT — 부서이동이력ID
  • user_account_id — BIGINT — Foreign key → user_account.user_account_id — NOT NULL — 사용자ID
  • from_dept — VARCHAR(50) — NOT NULL — 이전 부서
  • to_dept — VARCHAR(50) — NOT NULL — 이동 부서
  • reason — VARCHAR(500) — 이동 사유
  • transferred_at — DATETIME — NOT NULL — 이동일시
  • created_at — DATETIME — NOT NULL — 생성일시

document_revision

  • document_revision_id — BIGINT — 문서리비전ID
  • pi_header_id — VARCHAR(20) — Foreign key → pi_header.pi_header_id — PI헤더ID
  • po_header_id — VARCHAR(20) — Foreign key → po_header.po_header_id — PO헤더ID
  • revision_no — INT — NOT NULL — 리비전 번호
  • changed_by_id — BIGINT — Foreign key → user_account.user_account_id — NOT NULL — 변경자ID
  • changed_at — DATETIME — NOT NULL — 변경일시
  • reason — VARCHAR(500) — 변경 사유
  • snapshot — JSON — NOT NULL — 변경 전 스냅샷

email

  • email_id — VARCHAR(20) — 메일ID (EM-NNN)
  • client_id — VARCHAR(20) — Foreign key → client.client_id — NOT NULL — 거래처ID
  • document_type — VARCHAR(10) — 관련문서유형 (PI/PO/CI)
  • document_id — VARCHAR(20) — 관련문서ID
  • recipient — VARCHAR(200) — NOT NULL — 수신자 이메일
  • recipient_name — VARCHAR(100) — 수신자명
  • subject — VARCHAR(500) — NOT NULL — 제목
  • template — VARCHAR(100) — 템플릿
  • sent_date — DATETIME — NOT NULL — 발송일시
  • status — VARCHAR(20) — NOT NULL — 상태 (sent/failed/draft)
  • sender_id — BIGINT — Foreign key → user_account.user_account_id — NOT NULL — 발송자ID
  • created_at — DATETIME — NOT NULL — 생성일시

email_attachment

  • email_attachment_id — BIGINT — 메일첨부파일ID
  • email_id — VARCHAR(20) — Foreign key → email.email_id — NOT NULL — 메일ID
  • file_name — VARCHAR(300) — NOT NULL — 파일명
  • file_path — VARCHAR(500) — 파일경로
  • file_size — BIGINT — 파일크기 (bytes)
  • created_at — DATETIME — NOT NULL — 생성일시

login_history

  • login_history_id — BIGINT — 로그인이력ID
  • user_account_id — BIGINT — Foreign key → user_account.user_account_id — NOT NULL — 사용자ID
  • ip_address — VARCHAR(45) — IP주소
  • user_agent — VARCHAR(512) — 사용자 에이전트
  • login_at — DATETIME — NOT NULL — 로그인일시
  • success — BOOLEAN — NOT NULL — 성공여부

manager_transfer_history

  • manager_transfer_history_id — BIGINT — 담당자변경이력ID
  • client_id — VARCHAR(20) — Foreign key → client.client_id — NOT NULL — 거래처ID
  • from_manager_id — BIGINT — Foreign key → user_account.user_account_id — 이전 담당자ID
  • to_manager_id — BIGINT — Foreign key → user_account.user_account_id — NOT NULL — 변경 담당자ID
  • reason — VARCHAR(500) — 변경 사유
  • transferred_at — DATETIME — NOT NULL — 변경일시
  • created_at — DATETIME — NOT NULL — 생성일시

notification

  • notification_id — BIGINT — 알림ID
  • user_account_id — BIGINT — Foreign key → user_account.user_account_id — 수신 사용자ID (NULL=전체)
  • type — VARCHAR(20) — NOT NULL — 유형 (shipment/document/collection/issue/email)
  • title — VARCHAR(200) — NOT NULL — 제목
  • message — TEXT — 메시지
  • is_read — BOOLEAN — NOT NULL — 읽음여부
  • created_at — DATETIME — NOT NULL — 생성일시

pdf_document

  • pdf_document_id — BIGINT — PDF문서ID
  • pi_header_id — VARCHAR(20) — Foreign key → pi_header.pi_header_id — PI헤더ID
  • po_header_id — VARCHAR(20) — Foreign key → po_header.po_header_id — PO헤더ID
  • ci_header_id — VARCHAR(20) — Foreign key → ci_header.ci_header_id — CI헤더ID
  • pl_header_id — VARCHAR(20) — Foreign key → pl_header.pl_header_id — PL헤더ID
  • activity_package_id — VARCHAR(20) — Foreign key → activity_package.activity_package_id — 활동패키지ID
  • file_name — VARCHAR(300) — NOT NULL — 파일명
  • file_path — VARCHAR(500) — NOT NULL — 파일경로
  • file_size — BIGINT — 파일크기 (bytes)
  • generated_at — DATETIME — NOT NULL — 생성일시

pi_header

  • pi_header_id — VARCHAR(20) — PI헤더ID (PI-YYYY-NNN)
  • client_id — VARCHAR(20) — Foreign key → client.client_id — NOT NULL — 거래처ID
  • buyer_id — VARCHAR(20) — Foreign key → buyer.buyer_id — 바이어담당자ID
  • currency_id — VARCHAR(10) — Foreign key → currency.currency_id — NOT NULL — 통화
  • incoterms — VARCHAR(50) — 인코텀즈
  • payment_terms — VARCHAR(50) — 결제조건
  • delivery_date — DATE — 납기일
  • status — VARCHAR(20) — NOT NULL — 상태 (DRAFT/SENT/CONFIRMED/CANCELLED)
  • issue_date — DATE — NOT NULL — 발행일
  • total_amount — DECIMAL(18, 2) — NOT NULL — 총금액
  • manager_id — BIGINT — Foreign key → user_account.user_account_id — 담당자ID
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

pi_item

  • pi_item_id — BIGINT — PI품목ID
  • pi_header_id — VARCHAR(20) — Foreign key → pi_header.pi_header_id — NOT NULL — PI헤더ID
  • product_id — VARCHAR(20) — Foreign key → product.product_id — NOT NULL — 품목ID
  • qty — INT — NOT NULL — 수량
  • unit_price — DECIMAL(18, 4) — NOT NULL — 단가
  • amount — DECIMAL(18, 2) — NOT NULL — 금액
  • sort_order — INT — NOT NULL — 정렬순서

pl_header

  • pl_header_id — VARCHAR(20) — PL헤더ID (PL-YYYY-NNN)
  • ci_header_id — VARCHAR(20) — Foreign key → ci_header.ci_header_id — NOT NULL — CI헤더ID
  • po_header_id — VARCHAR(20) — Foreign key → po_header.po_header_id — NOT NULL — PO헤더ID
  • client_id — VARCHAR(20) — Foreign key → client.client_id — NOT NULL — 거래처ID
  • invoice_no — VARCHAR(50) — NOT NULL — 송장번호
  • invoice_date — DATE — NOT NULL — 송장일자
  • port_of_loading — VARCHAR(100) — 선적항
  • port_of_discharge — VARCHAR(100) — 도착항
  • carrier — VARCHAR(100) — 운송사
  • sailing_date — DATE — 출항일
  • total_net_weight — DECIMAL(12, 2) — 순중량 합계 (kg)
  • total_gross_weight — DECIMAL(12, 2) — 총중량 합계 (kg)
  • total_volume — DECIMAL(12, 2) — 용적 합계 (CBM)
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

pl_package

  • pl_package_id — BIGINT — PL포장ID
  • pl_header_id — VARCHAR(20) — Foreign key → pl_header.pl_header_id — NOT NULL — PL헤더ID
  • pkg_no — VARCHAR(20) — NOT NULL — 포장번호
  • pkg_type — VARCHAR(20) — NOT NULL — 포장유형 (BUNDLE/PALLET)
  • description — VARCHAR(300) — NOT NULL — 품목 설명
  • qty — INT — NOT NULL — 수량
  • unit — VARCHAR(20) — NOT NULL — 단위
  • net_weight — DECIMAL(12, 2) — 순중량 (kg)
  • gross_weight — DECIMAL(12, 2) — 총중량 (kg)
  • length_mm — INT — 길이 (mm)
  • width_mm — INT — 폭 (mm)
  • height_mm — INT — 높이 (mm)
  • volume_cbm — DECIMAL(10, 4) — 용적 (CBM)
  • hs_code — VARCHAR(20) — HS Code
  • dimension — VARCHAR(100) — 치수
  • sort_order — INT — NOT NULL — 정렬순서

po_header

  • po_header_id — VARCHAR(20) — PO헤더ID (PO-YYYY-NNN)
  • pi_header_id — VARCHAR(20) — Foreign key → pi_header.pi_header_id — 연결 PI헤더ID
  • client_id — VARCHAR(20) — Foreign key → client.client_id — NOT NULL — 거래처ID
  • buyer_id — VARCHAR(20) — Foreign key → buyer.buyer_id — 바이어담당자ID
  • currency_id — VARCHAR(10) — Foreign key → currency.currency_id — NOT NULL — 통화
  • incoterms — VARCHAR(50) — 인코텀즈
  • payment_terms — VARCHAR(50) — 결제조건
  • delivery_date — DATE — 납기일
  • status — VARCHAR(20) — NOT NULL — 상태 (RECEIVED/IN_PRODUCTION/SHIPPED/COMPLETED/CANCELLED)
  • issue_date — DATE — NOT NULL — 발행일
  • total_amount — DECIMAL(18, 2) — NOT NULL — 총금액
  • manager_id — BIGINT — Foreign key → user_account.user_account_id — 담당자ID
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

po_item

  • po_item_id — BIGINT — PO품목ID
  • po_header_id — VARCHAR(20) — Foreign key → po_header.po_header_id — NOT NULL — PO헤더ID
  • product_id — VARCHAR(20) — Foreign key → product.product_id — NOT NULL — 품목ID
  • qty — INT — NOT NULL — 수량
  • unit_price — DECIMAL(18, 4) — NOT NULL — 단가
  • amount — DECIMAL(18, 2) — NOT NULL — 금액
  • sort_order — INT — NOT NULL — 정렬순서

port

  • port_id — BIGINT — 항구ID
  • country_id — BIGINT — Foreign key → country.country_id — NOT NULL — 국가ID
  • name — VARCHAR(100) — NOT NULL — 항구명
  • created_at — DATETIME — NOT NULL — 생성일시

product

  • product_id — VARCHAR(20) — 품목ID (ITM-XXX)
  • name — VARCHAR(200) — NOT NULL — 영문 품목명
  • name_kr — VARCHAR(200) — 한글 품목명
  • unit — VARCHAR(20) — NOT NULL — 단위 (EA/KG/SET)
  • pack_unit — VARCHAR(20) — 포장단위 (BUNDLE/PALLET)
  • spec — VARCHAR(200) — 규격
  • unit_price — DECIMAL(18, 4) — NOT NULL — 기본 단가
  • weight — DECIMAL(12, 2) — 단위중량 (kg)
  • category — VARCHAR(50) — 카테고리
  • hs_code — VARCHAR(20) — HS Code
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

production_order

  • production_order_id — VARCHAR(20) — 생산지시서ID (MO-YYYY-NNN)
  • po_header_id — VARCHAR(20) — Foreign key → po_header.po_header_id — NOT NULL — PO헤더ID
  • client_id — VARCHAR(20) — Foreign key → client.client_id — NOT NULL — 거래처ID
  • status — VARCHAR(20) — NOT NULL — 상태 (PENDING/IN_PROGRESS/COMPLETED)
  • issue_date — DATE — NOT NULL — 발행일
  • due_date — DATE — 납기일
  • manager_id — BIGINT — Foreign key → user_account.user_account_id — 담당자ID
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

production_order_item

  • production_order_item_id — BIGINT — 생산지시품목ID
  • production_order_id — VARCHAR(20) — Foreign key → production_order.production_order_id — NOT NULL — 생산지시서ID
  • product_id — VARCHAR(20) — Foreign key → product.product_id — NOT NULL — 품목ID
  • qty — INT — NOT NULL — 수량
  • sort_order — INT — NOT NULL — 정렬순서

refresh_token

  • refresh_token_id — BIGINT — 리프레시토큰ID
  • user_account_id — BIGINT — Foreign key → user_account.user_account_id — NOT NULL — 사용자ID
  • token — VARCHAR(512) — NOT NULL — 토큰
  • expires_at — DATETIME — NOT NULL — 만료일시
  • revoked — BOOLEAN — NOT NULL — 폐기여부
  • created_at — DATETIME — NOT NULL — 생성일시

shipment

  • shipment_id — VARCHAR(20) — 출하ID (SH-YYYY-NNN)
  • po_header_id — VARCHAR(20) — Foreign key → po_header.po_header_id — NOT NULL — PO헤더ID
  • shipment_order_id — VARCHAR(20) — Foreign key → shipment_order.shipment_order_id — 출하지시서ID
  • ci_header_id — VARCHAR(20) — Foreign key → ci_header.ci_header_id — CI헤더ID
  • pl_header_id — VARCHAR(20) — Foreign key → pl_header.pl_header_id — PL헤더ID
  • client_id — VARCHAR(20) — Foreign key → client.client_id — NOT NULL — 거래처ID
  • client_name — VARCHAR(200) — 거래처명 (비정규화)
  • status — VARCHAR(20) — NOT NULL — 상태 (PREPARING/SHIPPED/IN_TRANSIT/ARRIVED/COMPLETED)
  • delay_status — VARCHAR(20) — 지연상태 (NORMAL/DELAY_RISK/DELAYED)
  • delay_memo — TEXT — 지연 사유
  • last_update — DATETIME — 최종 업데이트일시
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

shipment_item

  • shipment_item_id — BIGINT — 출하품목ID
  • shipment_id — VARCHAR(20) — Foreign key → shipment.shipment_id — NOT NULL — 출하ID
  • product_id — VARCHAR(20) — Foreign key → product.product_id — NOT NULL — 품목ID
  • qty — INT — NOT NULL — 수량
  • sort_order — INT — NOT NULL — 정렬순서

shipment_order

  • shipment_order_id — VARCHAR(20) — 출하지시서ID (SO-YYYY-NNN)
  • po_header_id — VARCHAR(20) — Foreign key → po_header.po_header_id — NOT NULL — PO헤더ID
  • production_order_id — VARCHAR(20) — Foreign key → production_order.production_order_id — 생산지시서ID
  • client_id — VARCHAR(20) — Foreign key → client.client_id — NOT NULL — 거래처ID
  • status — VARCHAR(20) — NOT NULL — 상태 (PENDING/READY/SHIPPED)
  • issue_date — DATE — NOT NULL — 발행일
  • due_date — DATE — 납기일
  • manager_id — BIGINT — Foreign key → user_account.user_account_id — 담당자ID
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

shipment_order_item

  • shipment_order_item_id — BIGINT — 출하지시품목ID
  • shipment_order_id — VARCHAR(20) — Foreign key → shipment_order.shipment_order_id — NOT NULL — 출하지시서ID
  • product_id — VARCHAR(20) — Foreign key → product.product_id — NOT NULL — 품목ID
  • qty — INT — NOT NULL — 수량
  • sort_order — INT — NOT NULL — 정렬순서

user_account

  • user_account_id — BIGINT — 사용자ID
  • name — VARCHAR(50) — NOT NULL — 이름
  • email — VARCHAR(100) — NOT NULL — 이메일
  • password_hash — VARCHAR(255) — NOT NULL — 비밀번호 해시
  • role — VARCHAR(20) — NOT NULL — 역할 (sales/production/shipping/admin)
  • dept — VARCHAR(50) — NOT NULL — 부서
  • status — VARCHAR(20) — NOT NULL — 상태 (active/inactive)
  • login_fail_count — INT — NOT NULL — 로그인 실패 횟수
  • account_locked — BOOLEAN — NOT NULL — 계정 잠금 여부
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시