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