ecount
Tables (13)
document_sequence
- seq_id — BIGSERIAL — Primary key — 시퀀스
- regex — VARCHAR(50)
material
- material_id — BIGSERIAL — Primary key — 원재료
- tenant_id — BIGINT — Foreign key → tenant.tenant_id — NOT NULL — 소속
- partner_id — BIGSERIAL — Foreign key → partner.partner_id — 거래처
- warehouse_id — BIGINT — Foreign key → warehouse.warehouse_id — 보관
- code — VARCHAR(50) — NOT NULL — 원재료
- name — VARCHAR(100) — NOT NULL — 원재료명
- specification (규격) — VARCHAR(200) — 규격
- unit (단위) — VARCHAR(20) — NOT NULL — 단위
- unit_price — NUMERIC(15,2) — 구매
- stock_quantity — NUMERIC(15,3) — NOT NULL — 재고수량
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — NOT NULL — 수정일시
metadata
- metadata_id — BIGSERIAL — Primary key — 메타데이터
- tenant_id — BIGINT — Foreign key → tenant.tenant_id — NOT NULL — 소속
- user_id — BIGSERIAL — Foreign key → users.user_id — 사용자
- domain (업무 타입) — VARCHAR(50) — 적용
- feature_type (Field2) — VARCHAR(50)
- field_key — VARCHAR(200) — NOT NULL — 속성
- properties — JSONB — NOT NULL — 속성값
- level — VARCHAR(20) — NOT NULL — 설정
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — NOT NULL — 수정일시
metadata_sequence (메타데이터사용정규식)
- metadata_sequence_id (Key) — Primary key — NOT NULL
- seq_id — BIGSERIAL — Foreign key → document_sequence.seq_id — 시퀀스
- metadata_id — BIGSERIAL — Foreign key → metadata.metadata_id — 메타데이터
partner (거래처)
- partner_id — BIGSERIAL — Primary key — 거래처
- tenant_id — BIGINT — Foreign key → tenant.tenant_id — NOT NULL — 소속
- code — VARCHAR(50) — NOT NULL — 거래처
- name — VARCHAR(100) — NOT NULL — 거래처명
- business_number — VARCHAR(20) — 사업자등록번호
- representative — VARCHAR(100) — 대표자명
- contact — VARCHAR(50) — 연락처
- address — VARCHAR(300) — 주소
- email — VARCHAR(200) — 이메일
- partner_type — VARCHAR(20) — NOT NULL — 거래유형
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — NOT NULL — 수정일시
product
- product_id — BIGSERIAL — Primary key — 품목
- tenant_id — BIGINT — Foreign key → tenant.tenant_id — NOT NULL — 소속
- warehouse_id — BIGINT — Foreign key → warehouse.warehouse_id — 보관
- code — VARCHAR(50) — NOT NULL — 품목
- name — VARCHAR(100) — NOT NULL — 품목명
- specification (규격) — VARCHAR(200) — 규격
- unit (단위) — VARCHAR(20) — NOT NULL — 단위
- selling_price (판매가) — NUMERIC(15,2) — NOT NULL — 판매가
- cost_price (원가) — NUMERIC(15,2) — 원가
- stock_quantity — NUMERIC(15,3) — NOT NULL — 재고수량
- category — VARCHAR(100) — 분류
- is_active — BOOLEAN — NOT NULL — 판매여부
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — NOT NULL — 수정일시
product_sale (판매 하단)
- tx_id — BIGSERIAL — Primary key
- product_id — BIGSERIAL — Foreign key → product.product_id — 품목
- sale_id — BIGSERIAL — Foreign key → sale.sale_id — 판매
- order (Field) — INTEGER
- quantity (quantity_delta) — NUMERIC(15,3) — NOT NULL
- total_sale (ps.quantity * p.selling_price) — NUMERIC(15,3)
- created_at — TIMESTAMP — NOT NULL
purchase
- purchase_id — BIGSERIAL — Primary key — 구매
- tenant_id — BIGINT — Foreign key → tenant.tenant_id — NOT NULL — 소속
- user_id — BIGSERIAL — Foreign key → users.user_id — 사용자
- partner_id — BIGINT — Foreign key → partner.partner_id — NOT NULL — 거래처
- purchase_number — VARCHAR(50) — 구매번호
- purchase_date — DATE — NOT NULL — 구매일자
- contact_info — VARCHAR(100) — 연락처
- status — VARCHAR(20) — NOT NULL — 상태
- note — TEXT — 비고
- total_amount — NUMERIC(15,2) — NOT NULL — 합계금액
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — NOT NULL — 수정일시
purchase_material (purchase_item)
- purchase_item_id — BIGSERIAL — Primary key — 구매구성목록
- purchase_id — BIGINT — Foreign key → purchase.purchase_id — NOT NULL — 구매
- material_id — BIGINT — Foreign key → material.material_id — NOT NULL — 원재료
- warehouse_id — BIGINT — Foreign key → warehouse.warehouse_id — 입고
- partner_id — BIGSERIAL — Foreign key → partner.partner_id — 거래처
- user_id — BIGSERIAL — Foreign key → users.user_id — 사용자
- quantity (얘만 있어도 될거같긴한데) — NUMERIC(15,3) — NOT NULL — 수량
- unit_price — NUMERIC(15,2) — NOT NULL — 단가
- amount — NUMERIC(15,2) — NOT NULL — 금액
- order (Field) — INTEGER
sale
- sale_id — BIGSERIAL — Primary key — 판매
- tenant_id — BIGINT — Foreign key → tenant.tenant_id — NOT NULL — 소속
- user_id — BIGSERIAL — Foreign key → users.user_id — 사용자
- partner_id — BIGINT — Foreign key → partner.partner_id — 거래처
- sale_number — VARCHAR(50) — 판매번호
- sale_date — DATE — NOT NULL — 판매일자
- contact_info — VARCHAR(100) — 연락처
- status — VARCHAR(20) — NOT NULL — 상태
- note — TEXT — 비고
- total_amount — NUMERIC(15,2) — NOT NULL — 합계금액
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — NOT NULL — 수정일시
tenant (고객사)
- tenant_id — BIGSERIAL — Primary key — 테넌트
- name — VARCHAR(100) — NOT NULL — 회사명
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — NOT NULL — 수정일시
users (사용자)
- user_id — BIGSERIAL — Primary key — 사용자
- tenant_id — BIGINT — Foreign key → tenant.tenant_id — NOT NULL — 소속
- email — VARCHAR(200) — NOT NULL — 이메일
- name — VARCHAR(100) — NOT NULL — 이름
- role (role //검토필요) — VARCHAR(50) — NOT NULL — 권한
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — NOT NULL — 수정일시
warehouse (창고)
- warehouse_id — BIGSERIAL — Primary key — 창고
- tenant_id — BIGINT — Foreign key → tenant.tenant_id — NOT NULL — 소속
- name — VARCHAR(100) — NOT NULL — 창고명
- address — VARCHAR(100) — 창고
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — NOT NULL — 수정일시