DB_SQL_IMPORT

Tables (5)

COMMERCIAL_INVOICE

  • CI_ID — VARCHAR(30) — Primary key — NOT NULL
  • REG_DT — TIMESTAMP — NOT NULL
  • SAILING_ON_OR_ABOUT — DATE — NOT NULL
  • MARKS — VARCHAR(100) — NOT NULL
  • PKGS_NO — VARCHAR(100) — NOT NULL
  • PORT_LOADING — VARCHAR(1000)
  • FINAL_DEST — VARCHAR(1000)
  • CONSIGNEE — VARCHAR(1000)
  • VSL — VARCHAR(20)
  • VOY — VARCHAR(10)
  • INCOTERMS — VARCHAR(20) — NOT NULL

COMMERCIAL_INVOICE_INFO

  • CI_ID — VARCHAR(30) — Foreign key → COMMERCIAL_INVOICE.CI_ID — NOT NULL
  • CI_NO — VARCHAR(30)
  • CI_DATE — DATE

COMPANY

  • COMPANY_ID — VARCHAR(30) — Primary key — NOT NULL
  • CI_ID — VARCHAR(30) — Foreign key → COMMERCIAL_INVOICE.CI_ID — NOT NULL
  • COMPANY_ADDRESS — VARCHAR(1000) — NOT NULL
  • COMPANY_NAME — VARCHAR(30) — NOT NULL
  • COMPANYTEL — VARCHAR(15)
  • COMPANY_FAX — VARCHAR(15)
  • ROLE — VARCHAR(1)

GOODS

  • GOODS_ID — VARCHAR(30) — Primary key — NOT NULL
  • CI_ID — VARCHAR(30) — Foreign key → COMMERCIAL_INVOICE.CI_ID — NOT NULL
  • GOODS — VARCHAR(100) — NOT NULL
  • UNIT_PRICE — DECIMAL(10,2) — NOT NULL
  • QTY — INT(255) — NOT NULL
  • DESCRIPTION_OF_GOODS — VARCHAR(100)

LETTTER_OF_CREDIT

  • CI_ID — VARCHAR(30) — Foreign key → COMMERCIAL_INVOICE.CI_ID — NOT NULL
  • LC_DATE — DATE
  • PAY_METHOD — VARCHAR(1000) — NOT NULL
  • LC_NO — VARCHAR(30)