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