Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    table

    Uploaded by

    siejuroa23

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    table

    Uploaded by

    siejuroa23
    3 views2 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    3 views2 pages

    table

    Uploaded by

    siejuroa23

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    User

    user_id username password user_type trail


    1 user1 password1 admin
    2 user2 password2 manager
    3 user3 password3 staff

    Supplies

    supply_id name quantity description


    111 soap 100 A basic cleaning supply
    222 detergent 150 For Washing Clothes
    333 bleach 50 For whitening and
    disinfecting fabrics

    Stores

    store_id name location contact_info


    101 Main Store 123 Main Street 09123456789
    102 Downtown Store 456 Elm Street 0987654321
    103 Westside Store 789 Oak Street 09123123125

    Services

    service_id name description status


    1001 Wash & Fold We was & fold your Active
    laundry
    1002 Dry cleaning We provide dry Active
    cleaning services
    1002 Alternations We offer Clothing Active
    Alternations

    Sales

    sales_id inventory_id quantity total_price sale_date


    8001 12345 5 50.00
    8002 23456 3 30.00
    8003 34567 2 20.00

    Payment

    Payment_id Order_id Payment_mode amount Payment_data


    5101 9101 Cash 50.00
    5102 9102 Gcash 75.50
    5103 9103 Cash 100.25
    Orders

    Order_id User_id Store_id Total_amount Payment_status Delivery_status Order_date


    9101 1 101 50.00 Paid Delivered
    9102 2 102 30.00 Paid In Process
    9103 3 103 20.00 Paid Pending

    Order Services

    Order_services_id Order_id Service_id quantity price


    2101 9101 1001 2 20.00
    2102 9102 1002 1 15.00
    2103 9103 1003 3 30.00

    Notifications

    Notification_id message User_id status date_created


    3001 Your laundry is 1 unread
    ready for pickup.
    3002 Delivery delayed 2 unread
    due to weather
    conditions.
    3003 Special offer: 20% 3 unread
    off on all services
    this weekend.

    Inventory

    Inventory_id Supply_id quantity Last_updated


    12345 111 100
    23456 222 150
    34567 333 50

    Discount

    Discount_id name description Discount_percentage Valid_until


    1101 Summer Sale 10% off on all 10.00
    services
    1102 Holiday Special 15% off for 15.00
    holiday season
    1103 New Year 20% off for New 20.00
    Discount Year celebration

    You might also like