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)