test

Tables (9)

BOARD

  • POST_ID — NUMBER
  • USER_ID — VARCHAR2(30) — NOT NULL
  • TITLE — VARCHAR2(100)
  • CONTENT — VARCHAR2(1000)
  • CREATED_DATE — DATE — NOT NULL
  • UPDATE_DATE — DATE
  • TYPE — NUMBER

FINISHED_PRODUCT

  • PRO_NO — NUMBER — NOT NULL
  • SALES_NO — NUMBER — NOT NULL
  • PRO_NAME — VARCHAR2(100)
  • PRO_STOCK — NUMBER
  • PRO_DETAIL — VARCHAR2(100)
  • PRO_PRICE — NUMBER
  • THUMBNAIL — VARCHAR2(500)

MATERIAL

  • MAT_NO — NUMBER — NOT NULL
  • METRIAL_NO — NUMBER — NOT NULL
  • MAT_NAME — VARCHAR2(100)
  • MAT_STOCK — NUMBER
  • MAT_DETAIL — VARCHAR2(100)
  • MAT_PRICE — NUMBER
  • THUMBNAIL — VARCHAR2(500)

MATERIAL_ORDER

  • METRIAL_NO — NUMBER — NOT NULL
  • ORDER_ID — NUMBER
  • SUPPLIER_ID — NUMBER
  • MATERIAL_ID — NUMBER
  • ORDER_QUANTITY — NUMBER
  • ORDER_DATE — DATE
  • DUE_DATE — DATE
  • ORDER_STATUS — VARCHAR2(50)

ORDERS

  • SALES_NO — NUMBER — NOT NULL
  • ORDER_DATE — DATE
  • ORDER_QUANTITY — NUMBER — NOT NULL
  • ORDER_TOTAL_AMOUT — NUMBER

RECIPE

  • PRO_NO — NUMBER — Primary key — NOT NULL
  • MAT_NO — NUMBER — Primary key — NOT NULL

RECIPE_DETAIL

  • RECIPE_DETAIL_ID — INT
  • RECIPE_ID — INT — NOT NULL
  • INGREDIENT_PRODUCT_ID — INT — NOT NULL
  • QUANTITY — DECIMAL(10,2)

SALES

  • SALES_NO — NUMBER — NOT NULL
  • SAL_DATE — DATE
  • SAL_QUANTITY — NUMBER — NOT NULL
  • SAL_TOTAL_AMOUT — NUMBER

USER

  • USER_ID — VARCHAR2(30) — NOT NULL
  • USER_PWD — VARCHAR2(100) — NOT NULL
  • COMPANY_NAME — VARCHAR2(15)
  • USER_NAME — VARCHAR2(15) — NOT NULL
  • PHONE — VARCHAR2(13) — NOT NULL
  • EMAIL — VARCHAR2(100) — NOT NULL
  • ENROLL_DATE — DATE
  • MODIFY_DATE — DATE
  • STATUS — VARCHAR2(1)
  • ROLE — CHAR(2) — NOT NULL
  • SALARY — NUMBER