Title

테이블 (25)

announcement

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • active — bit(1) — NOT NULL
  • content — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • pinned — bit(1) — NOT NULL
  • title — varchar(255) — NOT NULL

asn

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • asn_code — varchar(255) — NOT NULL
  • description — varchar(255)
  • expected_date — datetime(6)
  • status — enum('ACCEPTED','REJECTED')
  • purchase_order_id — bigint(20) — 외래 키 → 발주.id
  • vendor_id — bigint(20) — 외래 키 → 거래처.vendor_id — NOT NULL

location

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • capacity — int(11) — NOT NULL
  • description — varchar(500)
  • location_code — varchar(20) — NOT NULL
  • section — varchar(10) — NOT NULL
  • status — enum('AVAILABLE','CLOSED') — NOT NULL
  • used_capacity — int(11) — NOT NULL
  • vendor_id — bigint(20)
  • zone — varchar(10) — NOT NULL

notification

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • message — varchar(255)
  • read_at — datetime(6)
  • status — enum('READ','UNREAD')
  • inbound_id — bigint(20) — 외래 키 → 입고.id
  • inventory_id — bigint(20) — 외래 키 → 재고.id
  • member_id — bigint(20) — 외래 키 → 회원.id — NOT NULL
  • outbound_id — bigint(20) — 외래 키 → 출고.outbound_id

outbound_inventory_history

  • id — bigint(20) — 기본 키 — NOT NULL
  • lot_number — varchar(255)
  • quantity_changed — int(11) — NOT NULL
  • status — enum('CANCELLED','COMPLETED','PENDING')
  • task_id — bigint(20)
  • inventory_id — bigint(20) — 외래 키 → 재고.id
  • location_id — bigint(20) — 외래 키 → location.id
  • outbound_id — bigint(20) — 외래 키 → 출고.outbound_id
  • product_id — bigint(20) — 외래 키 → 상품.product_id

product_status_history

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • changed_by — varchar(255)
  • new_status — enum('ACTIVE','DISCONTINUED','INACTIVE')
  • old_status — enum('ACTIVE','DISCONTINUED','INACTIVE')
  • product_name — varchar(255)
  • product_id — bigint(20) — 외래 키 → 상품.product_id

warehouse

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • active — bit(1)
  • city — varchar(255)
  • country — varchar(255)
  • detail — varchar(255)
  • street — varchar(255)
  • zipcode — varchar(255)
  • email — varchar(255)
  • name — varchar(255)
  • phone_number — varchar(255)

가맹점 (franchise_store)

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • city — varchar(255)
  • country — varchar(255)
  • detail — varchar(255)
  • street — varchar(255)
  • zipcode — varchar(255)
  • api_key — varchar(255)
  • description — varchar(255)
  • email — varchar(100)
  • franchise_code — varchar(50) — NOT NULL
  • name — varchar(200) — NOT NULL
  • phone_number — varchar(20)
  • status — enum('ACTIVE','INACTIVE','SUSPENDED') — NOT NULL

거래처 (vendor)

  • vendor_id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • city — varchar(255)
  • country — varchar(255)
  • detail — varchar(255)
  • street — varchar(255)
  • zipcode — varchar(255)
  • api_key — varchar(255)
  • description — varchar(255)
  • email — varchar(100)
  • name — varchar(200) — NOT NULL
  • phone_number — varchar(20)
  • status — enum('ACTIVE','INACTIVE','SUSPENDED') — NOT NULL
  • vendor_code — varchar(50) — NOT NULL

검수_작업 (inspection_task)

  • id — bigint(20) — 기본 키 — NOT NULL
  • inbound_id — bigint(20)
  • task_id — bigint(20) — 외래 키 → 작업.id

발주 (purchase_order)

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • description — varchar(1000)
  • expected_date — datetime(6)
  • order_code — varchar(255) — NOT NULL
  • order_date — datetime(6)
  • rejected_at — datetime(6)
  • rejected_reason — varchar(255)
  • status — enum('APPROVED','AWAITING_DELIVERY','CANCELLED','COMPLETED','REQUESTED') — NOT NULL
  • total_amount — bigint(20)
  • vendor_id — bigint(20) — 외래 키 → 거래처.vendor_id — NOT NULL

발주_상품 (outbound_product_item)

  • id — bigint(20) — 기본 키 — NOT NULL
  • description — varchar(1000)
  • location_code — varchar(255)
  • ordered_quantity — int(11) — NOT NULL
  • order_product_item_id — bigint(20) — 외래 키 → 주문_상품.id
  • outbound_id — bigint(20) — 외래 키 → 출고.outbound_id — NOT NULL
  • product_id — bigint(20) — 외래 키 → 상품.product_id — NOT NULL

발주_상품 (purchase_order_product)

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • description — varchar(500)
  • ordered_quantity — int(11) — NOT NULL
  • product_id — bigint(20) — 외래 키 → 상품.product_id — NOT NULL
  • purchase_order_id — bigint(20) — 외래 키 → 발주.id — NOT NULL

상품 (product)

  • product_id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • description — varchar(1000)
  • name — varchar(200) — NOT NULL
  • product_code — varchar(50) — NOT NULL
  • status — enum('ACTIVE','DISCONTINUED','INACTIVE')
  • unit — varchar(50)
  • unit_price — bigint(20)
  • vendor_id — bigint(20) — 외래 키 → 거래처.vendor_id

상품_이미지 (image)

  • id — bigint(20) — 기본 키 — NOT NULL
  • file_name — varchar(255)
  • product_id — bigint(20) — 외래 키 → 상품.product_id

입고 (inbound)

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • description — varchar(255)
  • inbound_code — varchar(255) — NOT NULL
  • manager_name — varchar(255)
  • scheduled_date — datetime(6)
  • status — enum('ARRIVED','CANCELLED','COMPLETED','CREATED','INSPECTING','PUTAWAY','SCHEDULED')
  • worker_name — varchar(255)
  • purchase_order_id — bigint(20) — 외래 키 → 발주.id

입고_상품 (inbound_product)

  • inbound_product_item_id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • description — varchar(1000)
  • location_code — varchar(255)
  • lot_number — varchar(50)
  • received_quantity — int(11) — NOT NULL
  • inbound_id — bigint(20) — 외래 키 → 입고.id — NOT NULL
  • product_id — bigint(20) — 외래 키 → 상품.product_id — NOT NULL
  • purchase_order_product_item_id — bigint(20) — 외래 키 → 발주_상품.id

작업 (task)

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • assigned_at — datetime(6)
  • category — enum('INSPECTION','PACKING','PICKING','PUTAWAY') — NOT NULL
  • completed_at — datetime(6)
  • note — varchar(255)
  • reference_id — bigint(20)
  • started_at — datetime(6)
  • status — enum('ASSIGNED','CANCELLED','COMPLETED','IN_PROGRESS','PENDING') — NOT NULL
  • member_id — bigint(20) — 외래 키 → 회원.id

재고 (inventory)

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • description — varchar(1000)
  • lot_number — varchar(50)
  • quantity — int(11) — NOT NULL
  • inbound_id — bigint(20) — 외래 키 → 입고.id
  • location_id — bigint(20) — 외래 키 → location.id — NOT NULL
  • product_id — bigint(20) — 외래 키 → 상품.product_id — NOT NULL

적치_작업 (putaway_task)

  • id — bigint(20) — 기본 키 — NOT NULL
  • assigned_location_code — varchar(20)
  • inbound_id — bigint(20)
  • task_id — bigint(20) — 외래 키 → 작업.id

주문 (orders)

  • order_id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • description — varchar(1000)
  • due_date — datetime(6) — NOT NULL
  • order_code — varchar(255)
  • order_date — datetime(6) — NOT NULL
  • rejected_at — datetime(6)
  • rejected_reason — varchar(255)
  • status — enum('APPROVED','CANCELLED','DELIVERED','REQUESTED','SHIPPED')
  • franchise_store_id — bigint(20) — 외래 키 → 가맹점.id

주문_상품 (order_product_item)

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • description — varchar(500)
  • ordered_quantity — int(11) — NOT NULL
  • order_id — bigint(20) — 외래 키 → 주문.order_id — NOT NULL
  • product_id — bigint(20) — 외래 키 → 상품.product_id — NOT NULL

출고 (outbound)

  • outbound_id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • description — varchar(255)
  • outbound_code — varchar(255) — NOT NULL
  • outbound_type — enum('RETURN','SALE','TRANSFER')
  • scheduled_date — datetime(6)
  • status — enum('APPROVED','CANCELLED','INSPECTION','PACKING','PICKING','REQUESTED','SHIPPED')
  • order_id — bigint(20) — 외래 키 → 주문.order_id
  • member_id — bigint(20) — 외래 키 → 회원.id

피킹_작업 (picking_task)

  • id — bigint(20) — 기본 키 — NOT NULL
  • outbound_id — bigint(20)
  • task_id — bigint(20) — 외래 키 → 작업.id

회원 (member)

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • email — varchar(255)
  • join_at — datetime(6)
  • name — varchar(255)
  • password — varchar(255)
  • phone_number — varchar(255)
  • role — enum('ADMIN','MANAGER','WORKER')
  • status — enum('ACTIVE','INACTIVE','LOCK')