project2
테이블 (11)
L/C_신용장 (Untitled2)
- L/C2026-0001, L/C2026-0002, L/C2026-0003 (L/C_ID) — INT — 기본 키 — NOT NULL
- WOORI BANK (L/C_BANK) — VARCHAR(40)
- TXN2026-0522 (LC_NO) — VARCHAR(30)
- INV-2026-KYB02 (INVOIC_NO) — VARCHAR(60)
T/T_전신환송금 (Untitled)
- T/T2026-0001, T/T2026-0002 (T/T_ID) — INT — 기본 키 — NOT NULL
- HANA BANK (T/T_BANK) — VARCHAR(40)
- TXN2026-0523 (REMITTANCE_NO) — VARCHAR(30)
- INV-2026-COM01 (INVOICE_NO) — VARCHAR(60)
송장 마스터 (INVOICE_MASTER)
- 송장 마스터ID (INVOICE_MASTER_ID) — INT — 기본 키 — NOT NULL
- INV-2026-COM01 (INVOICE_NO_COMPUTER) — VARCHAR(60)
- INV-2026-KYB02 (INVOICE_NO_KEYBOARD) — VARCHAR(60)
- INV-2026-LPT03 (INVOICE_NO_LAPTOP) — VARCHAR(60)
- INV-2026-MSE04 (INVOICE_NO_MOUSE) — VARCHAR(60)
- INV-2026-MNT05 (INVOICE_NO_MONITOR) — VARCHAR(60)
- 2026-05-26 (DUE_DATE) — DATE
- 200 (TOTAL_QUANTITY) — INT
- 20,000,000(KRW) (TOTAL_AMOUNT) — INT
송장 상세_COM (INVOICE_DETAIL1)
- INV-2026-COM01 (INVOICE_NO) — VARCHAR(60) — 기본 키 — NOT NULL
- 40 (QUANTITY) — VARCHAR(20)
- 100,000(KRW) (LINE_TOTAL) — VARCHAR(30)
- 2026-05-23 (PAYMENT_DATE) — DATE
- Y (UNPAID_YN) — VARCHAR(5)
송장 상세_KEYBOARD (INVOICE_DETAIL2)
- INV-2026-KYB02 (INVOICE_NO) — VARCHAR(60) — 기본 키 — NOT NULL
- 40 (QUANTITY) — VARCHAR(20)
- 100,000(KRW) (LINE_TOTAL) — VARCHAR(30)
- 2026-05-22 (PAYMENT_DATE) — DATE
- Y (UNPAID_YN) — VARCHAR(5)
송장 상세_LAPTOP (INVOICE_DETAIL3)
- INV-2026-LPT03 (INVOICE_NO) — VARCHAR(60) — 기본 키 — NOT NULL
- 40 (QUANTITY) — VARCHAR(20)
- 100,000(KRW) (LINE_TOTAL) — VARCHAR(30)
- N (UNPAID_YN) — VARCHAR(5)
송장 상세_MONITOR (INVOICE_DETAIL5)
- INV-2026-MNT05 (INVOICE_NO) — VARCHAR(60) — 기본 키 — NOT NULL
- 40 (QUANTITY) — VARCHAR(20)
- 100,000(KRW) (LINE_TOTAL) — VARCHAR(30)
- N (UNPAID_YN) — VARCHAR(5)
송장 상세_MOUSE (INVOICE_DETAIL4)
- INV-2026-MSE04 (INVOICE_NO) — VARCHAR(60) — 기본 키 — NOT NULL
- 40 (QUANTITY) — VARCHAR(20)
- 100,000(KRW) (LINE_TOTAL) — VARCHAR(30)
- N (UNPAID_YN) — VARCHAR(5)
수입사(IMPORTER) (HS물산)
- 수입사ID (IMPORTER_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- HS물산 (IMPORTER_NAME) — VARCHAR(50)
- Korea (COUNTRY) — VARCHAR(30)
- KR323798 (TAX_ID) — VARCHAR(20)
주문 상세 (ORDER_DETAIL)
- ORD-20260510-01 (ORDER_NO) — VARCHAR(30) — 기본 키 — NOT NULL
- 40 (EACH_QUANTITY) — INT
- 200 (TOTAL_QUANTITY) — INT
- 100,000(KRW) (EACH_AMOUNT) — INT
- 20,000,000(KRW) (TOTAL_AMOUNNT) — INT
판매사(SUPPLIER) (LENOVO)
- 공급사ID (SUPPLIER_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- Lenovo (SUPPLIER_NAME) — VARCHAR(50)
- China (COUNTRY) — VARCHAR(30)
- Wu lei (MANAGER_NAME) — VARCHAR(20)
- [email protected] (CONTACT) — VARCHAR(30)
- LV458464 (TAX_ID) — VARCHAR(20)
- Computer (MAIN_PRODUCT) — VARCHAR(20)