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)