SFI

Tables (16)

TB_BRAND

  • brand_code — VARCHAR(20)
  • brand_name — VARCHAR(100) — NOT NULL
  • country_code — CHAR(2) — Foreign key → TB_COUNTRY.country_code — NOT NULL
  • description — TEXT

TB_COUNTRY

  • country_code — CHAR(2)
  • country_name_kr — VARCHAR(50) — NOT NULL
  • country_name_en — VARCHAR(50)
  • currency_code — CHAR(3) — NOT NULL

TB_EST

  • est_code — VARCHAR(20)
  • est_name — VARCHAR(100)
  • country_code — CHAR(2) — Foreign key → TB_COUNTRY.country_code — NOT NULL

TB_GRADE

  • grade_code — VARCHAR(10)
  • grade_name — VARCHAR(50) — NOT NULL
  • country_code — CHAR(2) — NOT NULL

TB_INVENTORY_LOT

  • lot_id — VARCHAR(50)
  • warehouse_code — VARCHAR(20) — NOT NULL
  • product_code — VARCHAR(20) — NOT NULL
  • purchase_date — DATE — NOT NULL
  • expiration_date — DATE — NOT NULL
  • initial_qty_box — INT — NOT NULL
  • initial_qty_kg — DECIMAL(12, 2) — NOT NULL
  • current_qty_box — INT — NOT NULL
  • current_qty_kg — DECIMAL(12, 2) — NOT NULL
  • unit_cost_krw — DECIMAL(12, 2) — NOT NULL
  • status — VARCHAR(10)

TB_OFFER

  • offer_no — VARCHAR(20)
  • agent_code — VARCHAR(20)
  • vendor_code — VARCHAR(20) — NOT NULL
  • offer_date — DATE — NOT NULL
  • contract_date — DATE
  • currency — CHAR(3) — NOT NULL
  • incoterms — VARCHAR(10)
  • status — VARCHAR(20)
  • shipment_period — VARCHAR(50)
  • created_at — DATETIME

TB_OFFER_DETAIL

  • offer_detail_id — BIGINT
  • offer_no — VARCHAR(20) — Foreign key → TB_OFFER.offer_no — NOT NULL
  • product_code — VARCHAR(20) — NOT NULL
  • unit_price — DECIMAL(10, 4) — NOT NULL
  • quantity_box — INT — NOT NULL
  • quantity_kg — DECIMAL(12, 2)

TB_PART

  • part_code — VARCHAR(10)
  • part_name — VARCHAR(50) — NOT NULL
  • species_code — VARCHAR(10) — Foreign key → TB_SPECIES.species_code — NOT NULL

TB_PARTNER

  • partner_code — VARCHAR(20)
  • partner_name — VARCHAR(100) — NOT NULL
  • partner_type — VARCHAR(10) — NOT NULL
  • biz_reg_no — VARCHAR(20)
  • representative — VARCHAR(50)
  • contact_info — VARCHAR(100)
  • credit_limit — DECIMAL(15, 2)

TB_PRODUCT

  • product_code — VARCHAR(20)
  • product_name — VARCHAR(100) — NOT NULL
  • species_code — VARCHAR(10) — NOT NULL
  • part_code — VARCHAR(10) — NOT NULL
  • brand_code — VARCHAR(20)
  • est_code — VARCHAR(20)
  • grade_code — VARCHAR(10)
  • origin_country — CHAR(2) — NOT NULL
  • storage_type — VARCHAR(10) — NOT NULL
  • weight_type — VARCHAR(10) — NOT NULL
  • std_box_weight — DECIMAL(10, 2)
  • is_active — CHAR(1)
  • created_at — DATETIME

TB_PURCHASE

  • purchase_no — VARCHAR(20)
  • offer_no — VARCHAR(20)
  • warehouse_code — VARCHAR(20) — NOT NULL
  • purchase_date — DATE — NOT NULL
  • bl_no — VARCHAR(50)
  • container_no — VARCHAR(50)
  • exchange_rate — DECIMAL(10, 2) — NOT NULL
  • total_amount_krw — DECIMAL(15, 0) — NOT NULL
  • status — VARCHAR(20)

TB_PURCHASE_ITEM

  • purchase_item_id — BIGINT
  • purchase_no — VARCHAR(20) — Foreign key → TB_PURCHASE.purchase_no — NOT NULL
  • product_code — VARCHAR(20) — NOT NULL
  • est_code — VARCHAR(20)
  • production_date — DATE
  • expiration_date — DATE — NOT NULL
  • qty_box — INT — NOT NULL
  • qty_kg — DECIMAL(12, 2) — NOT NULL
  • unit_cost_krw — DECIMAL(12, 2) — NOT NULL
  • trace_no — VARCHAR(50)

TB_SALES

  • sales_no — VARCHAR(20)
  • customer_code — VARCHAR(20) — NOT NULL
  • sales_date — DATE — NOT NULL
  • sales_type — VARCHAR(10)
  • total_supply_amt — DECIMAL(15, 0) — NOT NULL
  • total_vat_amt — DECIMAL(15, 0) — NOT NULL
  • remarks — TEXT

TB_SALES_ITEM

  • sales_item_id — BIGINT
  • sales_no — VARCHAR(20) — Foreign key → TB_SALES.sales_no — NOT NULL
  • lot_id — VARCHAR(50) — Foreign key → TB_INVENTORY_LOT.lot_id — NOT NULL
  • product_code — VARCHAR(20) — NOT NULL
  • qty_box — INT — NOT NULL
  • qty_kg — DECIMAL(12, 2) — NOT NULL
  • unit_price_krw — DECIMAL(12, 2) — NOT NULL
  • supply_amt — DECIMAL(15, 0) — NOT NULL
  • cost_basis_krw — DECIMAL(12, 2)

TB_SPECIES

  • species_code — VARCHAR(10)
  • species_name — VARCHAR(50) — NOT NULL

TB_WAREHOUSE

  • warehouse_code — VARCHAR(20)
  • warehouse_name — VARCHAR(100) — NOT NULL
  • location — VARCHAR(200)
  • is_bonded — CHAR(1)