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