Changes between Initial Version and Version 1 of StoreRegistration


Ignore:
Timestamp:
12/30/25 15:04:04 (15 hours ago)
Author:
235018
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • StoreRegistration

    v1 v1  
     1== Store and Owner Registration
     2
     3=== Authors: **Registered Boss**
     4
     5The user selects the option to register as a store owner.
     6
     7The system displays a registration form for personal and store data.
     8
     9The user submits personal information.
     10
     11The application inserts a new record into the {{{personal}}} table.
     12
     13
     14{{{#!sql
     15INSERT INTO personal (id, first_name, last_name, ssn, email, password)
     16VALUES ('0010001', 'Anna', 'Ivanova', '1234567890123', 'anna@store.com
     17', 'hashed_pw');
     18
     19}}}
     20
     21The application registers the user as a boss in {{{boss}}}.
     22
     23
     24{{{#!sql
     25INSERT INTO boss (boss_ID)
     26VALUES ('0010001');
     27
     28}}}
     29
     30The application creates a new store entry in {{{store}}}.
     31
     32
     33{{{#!sql
     34INSERT INTO store (store_ID, name, date_of_founding, physical_address, store_email)
     35VALUES ('001', 'HandCraft001', '2024-01-01',
     36'st.Main num.5, Skopje 1000, MK',
     37'store001@shop.com
     38');
     39
     40}}}