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