StockForge

Tables (19)

categories (카테고리)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 이름 (name) — VARCHAR(300) — NOT NULL
  • 설명 (description) — TEXT — NOT NULL
  • 생성일자 (created_at) — TIMESTAMP — NOT NULL
  • 수정일자 (updated_at) — TIMESTAMP — @UpdatedAt
  • 삭제일자 (deleted_at) — TIMESTAMP

category_properties (카테고리 속성 맵핑 테이블)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 속성 ID (property_id) — BIGINT — Foreign key → properties.ID — NOT NULL
  • 카테고리 ID (category_id) — BIGINT — Foreign key → categories.ID — NOT NULL
  • 생성일자 (created_at) — TIMESTAMP — NOT NULL
  • 필수여부 (is_required) — BOOLEAN — NOT NULL
  • 정렬순서 (sort_order) — INT — NOT NULL
  • 활성화 여부 (is_active) — BOOLEAN — NOT NULL

granted_permissions (부여된 권한)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 역할 ID (role_id) — BIGINT — Foreign key → roles.ID — NOT NULL
  • 권한 ID (permission_id) — BIGINT — Foreign key → permissions.ID — NOT NULL
  • 부여 일자 (granted_at) — TIMESTAMP — NOT NULL

inventory_doc (창고 내역 헤더)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 유저 ID (user_id) — BIGINT — Foreign key → users.ID — NOT NULL
  • 생성일자 (created_at) — TIMESTAMP — NOT NULL
  • 발행일자 (posted_at) — TIMESTAMP
  • 취소일자 (canceled_at) — TIMESTAMP
  • 타입 (type) — ENUM — NOT NULL — {"INBOUND","OUTBOUND","ADJUSTMENT","TRANSFER"}
  • 상태 (status) — ENUM — NOT NULL — {"DRAFT","POSTED","CANCELLED"}

inventory_doc_line (창고 내역)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 헤더 ID (header_id) — BIGINT — Foreign key → inventory_doc.ID — NOT NULL
  • 창고 ID (warehouse_id) — BIGINT — Foreign key → warehouses.ID — NOT NULL
  • 상품 ID (product_id) — BIGINT — Foreign key → products.ID — NOT NULL
  • 값 (qty) — INT — NOT NULL

inventory_event (창고 이벤트 내역)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 이벤트 타입 ID (event_type_id) — BIGINT — Foreign key → inventory_event_type.ID — NOT NULL
  • 내용 (content) — TEXT — NOT NULL
  • Field

inventory_event_type (Untitled)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 이름 (name) — VARCHAR(30) — NOT NULL
  • 타입 (type) — ENUM — NOT NULL — {"INFO","WARNING","ERROR"}}
  • 제목 (title) — TEXT — NOT NULL

inventory_transfer (창고 이동 내역)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 헤더 ID (header_id) — BIGINT — Foreign key → inventory_doc.ID — NOT NULL
  • 원본 내역 (source_line_id) — BIGINT — Foreign key → inventory_doc_line.ID — NOT NULL
  • 대상 내역 (target_line_id) — BIGINT — Foreign key → inventory_doc_line.ID — NOT NULL

login_histories (로그인 기록)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 유저 ID (user_id) — BIGINT — Foreign key → users.ID — NOT NULL
  • 타입 (type) — ENUM — NOT NULL — {"LOGIN","LOGOUT","EXPIRED","REFRESH","LOGIN_FAILED","PASSWORD_CHANGED","LOCKED","UNLOCKED","FORCED_LOGOUT"}
  • 발생일자 (occured_at) — TIMESTAMP — NOT NULL

permissions (권한)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 권한명 (name) — VARCHAR(100) — NOT NULL — @Unique
  • 설명 (description) — TEXT — NOT NULL
  • 생성일자 (created_at) — TIMESTAMP — NOT NULL
  • 수정일자 (updated_at) — TIMESTAMP — @UpdatedAt

product_embeddings (상품 임베딩)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 상품 ID (product_id) — BIGINT — Foreign key → products.ID — NOT NULL
  • 모델 (model) — TEXT — NOT NULL
  • 차원 (dims) — INT — NOT NULL
  • 원문 (search_corpus) — TEXT — NOT NULL
  • 해시 (content_hash) — TEXT — NOT NULL
  • 임베딩 (embedding) — VECTOR(3072) — NOT NULL
  • 상태 (status) — ENUM — NOT NULL — {"PENDING","READY","FAILED"}
  • 마지막 에러 (last_error) — TEXT
  • 생성일자 (created_at) — TIMESTAMP — NOT NULL
  • 수정일자 (updated_at) — TIMESTAMP — @UpdatedAt

product_properties (상품 속성)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 상품 ID (product_id) — BIGINT — Foreign key → products.ID — NOT NULL
  • 속성 ID (property_id) — BIGINT — Foreign key → properties.ID — NOT NULL
  • string 값 (string_value) — TEXT
  • number 값 (number_value) — DECIMAL(18,6)
  • boolean 값 (boolean_value) — BOOLEAN
  • date 값 (date_value) — DATETIME
  • 옵션 id (option_id) — BIGINT — Foreign key → property_options.ID

products (상품)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 카테고리 ID (category_id) — BIGINT — Foreign key → categories.ID — NOT NULL
  • 이름 (name) — VARCHAR(300) — NOT NULL
  • 설명 (description) — TEXT — NOT NULL
  • 생성일자 (created_at) — TIMESTAMP — NOT NULL
  • 수정일자 (updated_at) — TIMESTAMP — @updatedAt
  • 삭제일자 (deleted_at) — TIMESTAMP

properties (속성)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 속성명 (name) — VARCHAR(100) — NOT NULL
  • 타입 (type) — ENUM — NOT NULL — {"string","number","boolean","date","option"}
  • 설명 (description) — TEXT — NOT NULL
  • 생성일자 (created_at) — TIMESTAMP — NOT NULL
  • 수정일자 (updated_at) — TIMESTAMP
  • 삭제일자 (deleted_at) — TIMESTAMP

property_options (속성 옵션)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 속성 ID (property_id) — BIGINT — Foreign key → properties.ID — NOT NULL
  • 옵션명 (name) — VARCHAR(200) — NOT NULL
  • 설명 (description) — TEXT — NOT NULL
  • 옵션값 (value) — VARCHAR(200) — NOT NULL
  • 생성일자 (created_at) — TIMESTAMP — NOT NULL
  • 수정일자 (updated_at) — TIMESTAMP — @UpdatedAt
  • 삭제일자 (deleted_at) — TIMESTAMP

roles (역할)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 역할명 (name) — VARCHAR(20) — NOT NULL — @Unique
  • 설명 (description) — TEXT — NOT NULL
  • 생성일자 (created_at) — TIMESTAMP — NOT NULL
  • 수정일자 (updated_at) — TIMESTAMP — @UpdatedAt

stock_balance (창고별 재고)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 창고 ID (warehouse_id) — BIGINT — Foreign key → warehouses.ID — NOT NULL
  • 상품 ID (product_id) — BIGINT — Foreign key → products.ID — NOT NULL
  • 수량 (qty) — INT — NOT NULL
  • 설명 (description) — TEXT — NOT NULL
  • 수정일자 (updated_at) — TIMESTAMP — NOT NULL — @UpdatedAt
  • 삭제일자 (deleted_at) — TIMESTAMP

users (사용자)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 이름 (name) — VARCHAR(20) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • 패스워드 (password) — VARCHAR(200) — NOT NULL
  • 실패횟수 (failed) — INT — NOT NULL
  • 역할 ID (role_id) — BIGINT — Foreign key → roles.ID — NOT NULL
  • 생성일자 (created_at) — TIMESTAMP — NOT NULL
  • 수정일자 (updated_at) — TIMESTAMP — @UpdatedAt
  • 삭제일자 (deleted_at) — TIMESTAMP

warehouses (창고)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 창고명 (name) — VARCHAR(100) — NOT NULL
  • 설명 (description) — TEXT — NOT NULL
  • 생성일자 (created_at) — TIMESTAMP — NOT NULL
  • 수정일자 (updated_at) — TIMESTAMP — @UpdatedAt
  • 삭제일자 (deleted_at) — TIMESTAMP