Pocha-CM
Tables (22)
Admin
- Admin ID (Admin_ID) — nvarchar2(50) — NOT NULL
- Admin Password (Admin_Password) — nvarchar2(50) — NOT NULL
Branch
- Branch Number (Branch_Num) — number — Primary key — NOT NULL
- Branch Name (Branch_Name) — varchar2(200) — NOT NULL
- Branch Address (Branch_Address) — varchar2(500) — NOT NULL
- Branch Phone (Branch_Phone) — varchar2(20) — NOT NULL
Brand
- Brand Number (Brand_Num) — number — Primary key — NOT NULL
- Brand Name (Brand_Name) — varchar2(100) — NOT NULL
INVOICE ITEM (INVOICE_ITEM)
- INVOICE_ITEM_NUMBER (INVOICE_ITEM_NUM) — number — Primary key — NOT NULL
- Invoice Number (Invoice_num) — number — Foreign key → Invoice.Invoice Number — NOT NULL
- Item Number (Item_Num) — number — Foreign key → Items.Item Number — NOT NULL
- qty — number — NOT NULL
Invoice
- Invoice Number (Invoice_num) — number — Primary key — NOT NULL
- Invoice Serial Numer (Invoice_serial) — varchar(30)
- User Number (User_Num) — Number — Foreign key → user information.User Number — NOT NULL
- Invoice Date (Invoice_Date) — Date — NOT NULL
Item Category (Item_category)
- Item Category Number (Item_Cate_Num) — number — Primary key — NOT NULL
- Item Category Name (Item_Cate_Name) — varchar2(200) — NOT NULL
Items
- Item Number (Item_Num) — number — Primary key — NOT NULL
- Brand Number (Brand_Num) — number — Foreign key → Brand.Brand Number
- Item Category Number (Item_Cate_Num) — number — Foreign key → Item Category.Item Category Number — NOT NULL
- Item Name (Item_Name) — varchar2(500) — NOT NULL
- Item Code (Item_Code) — varchar2(20) — NOT NULL — unique
- Order Unit Number (Order_unit_num) — number — Foreign key → Order Unit.Order Unit Number — NOT NULL
- unit price (unit_price) — number — NOT NULL
- Target WastePercentage (tw_Percentage) — number — NOT NULL — percent
- Last Update (Last_Update_date) — date — NOT NULL
- User Number(Last Update User) (User_Num) — Number — Foreign key → user information.User Number — NOT NULL
- Supplier Number (Supplier_Num) — number — Foreign key → Supplier.Supplier Number — NOT NULL
Menu Raw Ingredient (Menu Raw_Ingredient)
- Raw Ingredients Number (Raw_Ingredients_Num) — number — Primary key — NOT NULL
- Menu Number (Menu_Num) — number — Foreign key → menu.Menu Number — NOT NULL
- Item Number (Item_Num) — number — Foreign key → Items.Item Number
- Item qty (Item_qty) — number — NOT NULL
Order Unit (Order_Unit)
- Order Unit Number (Order_unit_num) — number — Primary key — NOT NULL
- Order Unit (order_unit) — varchar2(15) — NOT NULL
Position
- Position Number (Position_Num) — number — Primary key — NOT NULL
- Position Name (Position_Name) — varchar2(100) — NOT NULL
Primary Unit (Primary_Unit)
- Primary Unit Number (Primary_Unit_Num) — number — Primary key — NOT NULL
- Item Number (Item_Num) — number — Foreign key → Items.Item Number — NOT NULL
- Primary Unit Name (Primary_Unit) — varchar2(15) — NOT NULL
- Primary Unit Quantity (Primary_Unit_Qty) — number(5) — NOT NULL
Processed Ingredient (Processed_Ingredient)
- Processed_Ingredients Number (Proc_Ingredients_Num) — number — Primary key — NOT NULL
- Processed_Ingredients Name (Proc_Ingredients_Name) — varchar2(500) — NOT NULL
- processed_ingredient_description (pro_ingredient_descript) — varchar2(3000)
Sales Source (Sales_Source)
- SALES_SOURCE_NUM — number — Primary key — NOT NULL
- SALES_SOURCE_NAME — varchar2(10) — NOT NULL
Sales invoice
- Sales invoice Number (Sales_invoice_num) — number — Primary key — NOT NULL
- User Number (User_Num) — Number — Foreign key → user information.User Number — NOT NULL
- Sales_Date — Date — NOT NULL
- Sales Quantity (Sales_qty) — number — NOT NULL
- SALES_SOURCE_NUM — number — Foreign key → Sales Source.SALES_SOURCE_NUM — NOT NULL
- Menu Number (Menu_Num) — number — Foreign key → menu.Menu Number — NOT NULL
Secondary Unit (Secondary_Unit)
- Secondary Unit Number (Secondary_Unit_Num) — number — Primary key — NOT NULL
- Item Number (Item_Num) — number — Foreign key → Items.Item Number — NOT NULL
- Secondary Unit Name (Secondary_Unit) — varchar2(15) — NOT NULL
- Secondary Unit Quantity (Secondary_Unit_Qty) — number(5) — NOT NULL
Supplier
- Supplier Number (Supplier_Num) — number — Primary key — NOT NULL
- Supplier Name (Supplier_Name) — varchar2(200) — NOT NULL
menu (MENU)
- Menu Number (Menu_Num) — number — Primary key — NOT NULL
- Menu name (Menu_Name) — varchar2(500) — NOT NULL
- Menu Price (Menu_Price) — number
- menu subcategory number (menu_subcate_num) — number — Foreign key → menu subcategory.menu subcategory number — NOT NULL
menu category (menu_category)
- menu category number (menu_cate_num) — number — Primary key — NOT NULL
- menu category name (menu_cate_name) — varchar2(500) — NOT NULL
menu subcategory (menu_subcategory)
- menu subcategory number (menu_subcate_num) — number — Primary key — NOT NULL
- menu subcategory name (menu_subcate_name) — varchar2(500) — NOT NULL
- menu category number (menu_cate_num) — number — Foreign key → menu category.menu category number — NOT NULL
menu_processed_ingredient_list (menu_pro_ingredient_list)
- MENU processed ingredient (menu_pro_ingredient_num) — number — Primary key — NOT NULL
- Menu Number (Menu_Num) — number — Foreign key → menu.Menu Number — NOT NULL
- Processed_Ingredients Number (Proc_Ingredients_Num) — number — Foreign key → Processed Ingredient.Processed_Ingredients Number — NOT NULL
pro raw ingredient (Pro_raw_ingredient)
- Pro_raw_ingredients_number (Pro_raw_ingredients_num) — number — Primary key — NOT NULL
- Processed_Ingredients Number (Proc_Ingredients_Num) — number — Foreign key → Processed Ingredient.Processed_Ingredients Number — NOT NULL
- Item Number (Item_Num) — number — Foreign key → Items.Item Number — NOT NULL
- raw ing Qty (Raw_Ingredients_Qty) — number — NOT NULL
user information (user_info)
- User Number (User_Num) — Number — Primary key — NOT NULL
- User E-mail (User_email) — varchar2(100) — NOT NULL
- User Password (User_Password) — varchar2(20) — NOT NULL
- User Name (User_Name) — varchar2(100) — NOT NULL
- User Gender (User_Gender) — number — NOT NULL
- Phone Number (User_Phone) — varchar2(20) — NOT NULL
- Date of Birth (Date_of_Birth) — date — NOT NULL
- Branch Number (Branch_Num) — number — Foreign key → Branch.Branch Number — NOT NULL
- Position Number (Position_Num) — number(1) — Foreign key → Position.Position Number — NOT NULL
- Work Start Date (Work_Start_Date) — date — NOT NULL
- Emergency Contact Name (Emer_Name) — varchar2(100)
- Emmergency Contact Phone (Emer_Phone) — varchar2(20)
- Tax File Check (Tax_File_Check) — number(1) — NOT NULL
- tAX fILE nUMBER (Tax_File_Num) — number(9) — NOT NULL
- BSB Number (BSB_Num) — number(6) — NOT NULL
- Bank Account Number (Bank_Account_Num) — number(12) — NOT NULL
- Superannuation Fund Name (SA_Fund_Name) — varchar2(100) — NOT NULL
- Superannuation Fund Number (SA_Fund_Num) — varchar2(100) — NOT NULL
- Home Address Line 1 (Address_L1) — varchar2(100) — NOT NULL
- Home Address Line 2 (Address_L2) — varchar2(100)
- Home Address State (Address_State) — varchar2(10) — NOT NULL
- Home Address Suburb (Address_Sub) — varchar2(10) — NOT NULL
- Home Address Postcode (Address_Postcode) — number(4) — NOT NULL
- Terms Agreement (Terms_Agree) — number(1) — NOT NULL
- Sign Up Date (Sign_up_date) — date — NOT NULL
- validation_by_sup — number — NOT NULL
- User Activate (User_Activate) — number — NOT NULL