ㅇㄴ
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)