wd
Tables (35)
ACCOUNT_ACTION
- ACTION_ID — NUMBER
- MEMBER_ID — NUMBER — NOT NULL
- ACTION_TYPE — VARCHAR2(50)
- ACTION_DATE — DATE
- ADMIN_ID — NUMBER
AFTER_SERVICE
- AS_ID — NUMBER
- ORDER_ID — NUMBER
- REQUEST — VARCHAR2(500)
- STATUS — VARCHAR2(20)
- CREATED_AT — DATE
CONFERENCE
- CONF_ID — NUMBER
- TITLE — VARCHAR2(200)
- START_TIME — DATE
- END_TIME — DATE
- PARTICIPANTS — VARCHAR2(500)
CONTRACT
- CONTRACT_ID — NUMBER
- QUOTATION_ID — NUMBER — NOT NULL
- BUYER_ID — NUMBER — NOT NULL
- STATUS — VARCHAR2(20)
- DOWN_PAYMENT — NUMBER
- BALANCE — NUMBER
- SIGNED_AT — DATE
CONTRACT_HISTORY
- HISTORY_ID — NUMBER
- CONTRACT_ID — NUMBER — NOT NULL
- STATUS — VARCHAR2(20)
- UPDATED_AT — DATE
- UPDATED_BY — NUMBER
COST_MANAGEMENT
- COST_ID — NUMBER
- ORDER_ID — NUMBER
- MATERIAL_COST — NUMBER
- PRODUCTION_COST — NUMBER
- LOGISTICS_COST — NUMBER
- TOTAL_COST — NUMBER
DEFECT_REPORT
- REPORT_ID — NUMBER
- QC_ID — NUMBER — NOT NULL
- DESCRIPTION — VARCHAR2(500)
- REPORTED_AT — DATE
DELIVERY
- DELIVERY_ID — NUMBER
- ORDER_ID — NUMBER
- DELIVERY_DATE — DATE
- STATUS — VARCHAR2(20)
DOCUMENT
- DOC_ID — NUMBER
- TITLE — VARCHAR2(200)
- TYPE — VARCHAR2(50)
- CONTENT — VARCHAR2(2000)
- CREATED_AT — DATE
DOCUMENT_TREE
- NODE_ID — NUMBER
- DOC_ID — NUMBER
- PARENT_ID — NUMBER
- NAME — VARCHAR2(200)
ERP_CONFIG
- CONFIG_ID — NUMBER
- KEY — VARCHAR2(100)
- VALUE — VARCHAR2(200)
EXCHANGE_RATE
- RATE_ID — NUMBER
- CURRENCY — VARCHAR2(20)
- RATE — NUMBER
- UPDATED_AT — DATE
IMAGE_REVIEW
- REVIEW_ID — NUMBER
- IMAGE_ID — NUMBER — NOT NULL
- BUYER_ID — NUMBER — NOT NULL
- STATUS — VARCHAR2(20)
- REVIEW_DATE — DATE
INVENTORY
- INVENTORY_ID — NUMBER
- MATERIAL_NAME — VARCHAR2(100)
- QUANTITY — NUMBER
- COST — NUMBER
- UPDATED_AT — DATE
INVENTORY_TRANSACTION
- TRANS_ID — NUMBER
- INVENTORY_ID — NUMBER — NOT NULL
- QUANTITY — NUMBER
- ACTION_TYPE — VARCHAR2(20)
- TRANS_DATE — DATE
MATERIAL_SUPPLIER
- SUPPLIER_ID — NUMBER
- NAME — VARCHAR2(200)
- CONTACT — VARCHAR2(100)
- ADDRESS — VARCHAR2(200)
MATERIAL_USAGE
- USAGE_ID — NUMBER
- PRODUCTION_ID — NUMBER — NOT NULL
- MATERIAL_NAME — VARCHAR2(100)
- QUANTITY_USED — NUMBER
- UPDATED_AT — DATE
MEMBER
- MEMBER_ID — NUMBER
- ROLE — VARCHAR2(20) — NOT NULL
- NAME — VARCHAR2(100) — NOT NULL
- EMAIL — VARCHAR2(100) — NOT NULL
- PASSWORD — VARCHAR2(100) — NOT NULL
- STATUS — VARCHAR2(20)
- CREATED_AT — DATE
MEMBER_ROLE
- MEMBER_ID — NUMBER
- ROLE_ID — NUMBER
NOTIFICATION
- NOTI_ID — NUMBER
- MEMBER_ID — NUMBER
- MESSAGE — VARCHAR2(500)
- CREATED_AT — DATE
- STATUS — VARCHAR2(20)
ORDER_HISTORY
- HISTORY_ID — NUMBER
- ORDER_ID — NUMBER — NOT NULL
- STATUS — VARCHAR2(20)
- UPDATED_AT — DATE
- UPDATED_BY — NUMBER
PAYMENT
- PAYMENT_ID — NUMBER
- CONTRACT_ID — NUMBER — NOT NULL
- AMOUNT — NUMBER — NOT NULL
- PAYMENT_DATE — DATE
- METHOD — VARCHAR2(50)
PAYMENT_STATUS
- STATUS_ID — NUMBER
- PAYMENT_ID — NUMBER — NOT NULL
- STATUS — VARCHAR2(20)
- UPDATED_AT — DATE
PRODUCTION
- PRODUCTION_ID — NUMBER
- ORDER_ID — NUMBER — NOT NULL
- STAFF_ID — NUMBER
- START_DATE — DATE
- END_DATE — DATE
- STATUS — VARCHAR2(20)
PRODUCT_IMAGE
- IMAGE_ID — NUMBER
- ORDER_ID — NUMBER — NOT NULL
- URL — VARCHAR2(200)
- COLOR — VARCHAR2(50)
- DEFECT_FLAG — CHAR(1)
PRODUCT_ORDER
- ORDER_ID — NUMBER
- CONTRACT_ID — NUMBER — NOT NULL
- PRODUCT_NAME — VARCHAR2(200)
- QUANTITY — NUMBER — NOT NULL
- ORDER_DATE — DATE
- STATUS — VARCHAR2(20)
QUALITY_CHECK
- QC_ID — NUMBER
- PRODUCTION_ID — NUMBER — NOT NULL
- RESULT — VARCHAR2(20)
- DEFECT_RATE — NUMBER
- REPORT_DATE — DATE
QUALITY_REVIEW
- REVIEW_ID — NUMBER
- QC_ID — NUMBER — NOT NULL
- BUYER_ID — NUMBER — NOT NULL
- STATUS — VARCHAR2(20)
- REVIEW_DATE — DATE
QUOTATION
- QUOTATION_ID — NUMBER
- INQUIRY_ID — NUMBER — NOT NULL
- COUNTRY — VARCHAR2(50)
- UNIT_PRICE — NUMBER
- LOGISTICS_COST — NUMBER
- SAMPLE_COST — NUMBER
- TOTAL_PRICE — NUMBER
- CREATED_AT — DATE
QUOTATION_REVIEW
- REVIEW_ID — NUMBER
- QUOTATION_ID — NUMBER — NOT NULL
- BUYER_ID — NUMBER — NOT NULL
- STATUS — VARCHAR2(20)
- REVIEW_DATE — DATE
SCHEDULE
- SCHEDULE_ID — NUMBER
- ORDER_ID — NUMBER
- TITLE — VARCHAR2(200)
- START_DATE — DATE
- END_DATE — DATE
- TYPE — VARCHAR2(50)
SYSTEM_LOG
- LOG_ID — NUMBER
- MEMBER_ID — NUMBER
- ACTION — VARCHAR2(200)
- CREATED_AT — DATE
TAX_POLICY
- POLICY_ID — NUMBER
- COUNTRY — VARCHAR2(50)
- TAX_RATE — NUMBER
- UPDATED_AT — DATE
USER_ROLE
- ROLE_ID — NUMBER
- ROLE_NAME — VARCHAR2(50)
- DESCRIPTION — VARCHAR2(200)
WORK_ASSIGNMENT
- ASSIGN_ID — NUMBER
- PRODUCTION_ID — NUMBER — NOT NULL
- STAFF_ID — NUMBER — NOT NULL
- ASSIGNED_AT — DATE