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 — 수정일시