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)