ㅇㄴ

Tables (14)

ASSET

  • PRODUCT_ID — INT — Primary key — NOT NULL
  • PRODUCT_NAME — VARCHAR(255)
  • TYPE — VARCHAR(255)
  • COMPANY_INFO — VARCHAR(255)
  • MANUFACURER — VARCHAR(255)
  • UNIT_PRICE — DOUBLE
  • Qty_ID — INT — NOT NULL

ASSET_INVOICE

  • ASSET_INVOICE_ID — INT — Primary key — NOT NULL
  • QTY — INT
  • INVOICE_NUMBER — INT — NOT NULL
  • PRODUCT_ID — INT — NOT NULL

ASSET_PURCHASE_ORDER

  • ASSET_PURCHASE_ORDER_ID — INT — Primary key — NOT NULL
  • TOTAL_ORDER_AMT — DOUBLE
  • PURCHASE_DATE — DATE
  • QTY — INT
  • TOTAL_PRICE — DOUBLE
  • EMP_ID — INT — NOT NULL
  • PRODUCT_ID — INT — NOT NULL

BUSINESS_LOCATION

  • LOCATION_ID — INT — Primary key — NOT NULL
  • LOCATION_NAME — VARCHAR(255)
  • LOCATION_ADD. — VARCHAR(255)
  • POSTAL_CODE — VARCHAR(255)
  • LOCATION_TEL — VARCHAR(255)
  • OWNER_TEL — VARCHAR(255)
  • OWNER_NAME — VARCHAR(255)
  • FAX_NUM — VARCHAR(255)
  • MANAGER_NAME — VARCHAR(255)

CONTRACT

  • AGREEMENT_ID — INT — Primary key — NOT NULL
  • START_DATE — DATE
  • END_DATE — DATE
  • REV._RATIO — DOUBLE
  • LOCATION_ID — INT — NOT NULL

DEPARTMENT

  • DEPT_ID — INT — Primary key — NOT NULL
  • DEPT_NAME — VARCHAR(255)
  • POSTAL_CODE — VARCHAR(255)
  • LOCATION_ADDRESS — VARCHAR(255)
  • DEPT_TEL_NO. — VARCHAR(255)
  • DEPT_FAX_NO. — VARCHAR(255)

EMPLOYEE

  • EMP_ID — INT — Primary key — NOT NULL
  • EMP_NAME — VARCHAR(255)
  • EMP_PHONE_NUM. — VARCHAR(255)
  • EMP_DEPT — VARCHAR(255)
  • DEPT_ID — INT — NOT NULL
  • EMP_ID2 — INT — NOT NULL

INVOICE

  • INVOICE_NUMBER — INT — Primary key — NOT NULL
  • INVOICE_DATE — DATE
  • SHIP_DATE — DATE
  • TERM — VARCHAR(255)
  • CUSTORMER_NO. — INT
  • SUB_TOTAL — INT
  • SHIPPING_CHARGE — DOUBLE
  • SALES_TAX — DOUBLE
  • CREDIT_DUE — DATE
  • TOTAL_DUE — DATE
  • VENDOR_ID — INT — NOT NULL

MACHINE

  • SERIAL_NO. — INT — Primary key — NOT NULL
  • PURCHASE_DATE — DATE
  • PURCHASE_PRICE — DOUBLE
  • REPAIR_COUNT — INT
  • STATUS — VARCHAR(255)
  • INVOICE_NUMBER — INT — NOT NULL
  • AGREEMENT_ID — INT — NOT NULL

MOVEMENT

  • MOVEMENT_ID — INT — Primary key — NOT NULL
  • MOVEMENT_DATE — DATE
  • TYPE — VARCHAR(255)
  • MO_ID — INT — NOT NULL
  • SERIAL_NO.2 — INT — NOT NULL

MOVE_ORDER

  • MO_ID — INT — Primary key — NOT NULL
  • MO_DATE — DATE
  • EMP_ID — INT — NOT NULL

PURCHASE_REQUEST

  • PR_ID — INT — Primary key — NOT NULL
  • PR_DATE — DATE
  • COMMENT — TEXT
  • EMP_ID — INT — NOT NULL
  • LOCATION_ID — INT — NOT NULL
  • Qty_ID — INT — NOT NULL

Purchase_Qty

  • Qty_ID — INT — Primary key — NOT NULL
  • Qty — INT

VENDOR

  • VENDOR_ID — INT — Primary key — NOT NULL
  • VENDOR_NAME — VARCHAR(255)
  • VENDOR_ADDRESS — VARCHAR(255)
  • VENDOR_PO_CODE — VARCHAR(255)
  • VENDOR_TEL_NO. — VARCHAR(255)
  • VENDOR_FAX_NO. — VARCHAR(255)