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')