- global
- inventory
- store
Table Name | Primary Key(s) | Foreign key(s) | Referring attribute |
---|---|---|---|
article_list | id | INV_suppliers_list.id | supplier_id |
article_group | id | / | / |
article_sub_group | id | GL_article_group.id GL_article_sub_group.id |
group_id sub_group_id |
article_grouping_connection | id | GL_article_group.id GL_article_sub_group.id GL_article_list.id |
group_id sub_group_id article_id |
shops_list | id | / | / |
inventory_list | id | / | / |
working_hours | id | GL_shops_list.id | shop_id |
corpo_buyers_list | id | / | / |
access_level_accounts | id | / | / |
retail_costs | id | GL_shops_list.id GL_retail_costs_types.id |
shop_id type_of_pay |
retail_costs_types | id | / | / |
- GL_article_list - articles present in the retail system
- GL_article_group - grouping articles for the sake of easier internal organization
- GL_article_sub_group - another level of grouping (related article group)
- GL_article_grouping_connection - tracking connection between article and group
- GL_shops_list - retail shops consisting inside company that is using software
- GL_inventory_list - inventories consisting inside company that is using software
- GL_working_hours - shop working hours
- GL_corpo_buyers_list - shop client companies
- GL_access_level_accounts - contains various information about users, admins and workers
- GL_retail_costs - consists of costs (bills ,invoices) retail may come across
- GL_retail_costs_types - types of retail costs (electrical power, water, internet, supplier invoices)
Table Name | Primary Key(s) | Foreign key(s) | Referring attribute |
---|---|---|---|
state | id | GL_article_list.id GL_inventory_list.id |
article_id inventory_id |
procurement | id | INV_suppliers_list.id GL_inventory_list.id |
supplier_id inventory_id |
procurement_items | id | INV_procurement.id GL_article_list.id |
procurement_id article_id |
delivery | id | GL_shops_list.id GL_inventory_list.id |
shop_id inventory_id |
delivery_items | id | GL_shops_list.id GL_article_list.id |
shop_id article_id |
suppliers_list | id | / | / |
- INV_state - items/goods present in invertory
- INV_procurement - every procurement request
- INV_procurement_items - procurement list of items
- INV_delivery - contains information about sending goods from inventory to store(s)
- INV_delivery_items - delivery list of articles
- INV_suppliers_list - contains information about all suppliers
Table Name | Primary Key(s) | Foreign key(s) | Referring attribute |
---|---|---|---|
state | id | GL_shops_list.id GL_article_list.id |
shop_id article_id |
fiscal_bills | id | GL_access_level_accounts.id GL_shops_list.id GL_corpo_buyers_list.id |
worker_id shop_id buyer_id |
sold_goods | id | RT_fiscal_bills.id GL_article_list.id |
fiscal_bill_id article_id |
order_request | id | GL_inventory_list.id GL_shops_list.id |
inventory_id shop_id |
order_request_items | id | RT_order_request.id GL_article_list.id |
request_id article_id |
corpo_sell_invoice | id | GL_corpo_buyers_list.id GL_access_level_accounts.id GL_shops_list.id |
corpo_id worker_id shop_id |
invoice_sold_items | id | RT_corpo_sell_invoice.id GL_article_list.id |
invoice_id article_id |
corpo_fiscal_bill | id | GL_corpo_buyers_list.id GL_shops_list.id RT_fiscal_bills.id |
corpo_id shop_id fiscal_bill_id |
- RT_state - items/goods present in shop/market
- RT_fiscal_bills - contains information about fiscal billing
- RT_sold_goods - contains information about goods sold
- RT_order_request - contains information about need order to the inventory (shortage of items in shop)
- RT_order_request_items - contains information about items needed in shop (related to RT_need_order)
- RT_corpo_sell_invoice - contains information about selling items to companies over invoices
- RT_invoice_sold_items - list of items sold over invoice
- RT_corpo_fiscal_bill - contains information about selling items to companies over cash (fiscal bills)
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
barcode* | varchar | ❌ | ❌ | ✅ | Barcode of an item, can be multiple referencing |
article_name | varchar | ❌ | ❌ | ❌ | Full article name |
tax_id | int | ❌ | ❌ | ❌ | Controls TAX % in cash register (DEFAULT 0) |
description | text | ❌ | ❌ | ✅ | Description of an article |
article_note | text | ❌ | ❌ | ✅ | Additional info about product |
exp_date | date | ❌ | ❌ | ✅ | Expiration date of an article |
supplier_id | int | ❌ | ✅ | ✅ | Unique identification value for suppliers , (Reference to supplier) |
service | boolean | ❌ | ❌ | ❌ | Either service or selling point |
discount | int | ❌ | ❌ | ✅ | Article discount |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
group_name | varchar | ❌ | ❌ | ❌ | Referencing name of the group |
group_color | varchar | ❌ | ❌ | ✅ | OPTIONAL: sorting articles by color |
discount_amount | int | ❌ | ❌ | ✅ | Amount of discount on article price |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
group_id | int | ❌ | ✅ | ❌ | Referencing group it belongs to |
sub_group_id | int | ❌ | ✅ | ✅ | OPTIONAL: If sub-group belongs to another sub-group |
sub_group_name | varchar | ❌ | ❌ | ❌ | Name of the sub-group |
sub_group_color | varchar | ❌ | ❌ | ✅ | OPTIONAL: sorting articles by color |
discount_amount | int | ❌ | ❌ | ✅ | Amount of discount on article price |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
group_id | int | ❌ | ✅ | ✅ | Referencing group |
sub_group_id | int | ❌ | ✅ | ✅ | Referencing sub-group |
article_id | int | ❌ | ✅ | ❌ | Referencing article |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
name | varchar | ❌ | ❌ | ❌ | Name of workplace |
address | varchar | ❌ | ❌ | ✅ | Address of workplace |
city | varchar | ❌ | ❌ | ✅ | City where workplace is located |
postal_code | varchar | ❌ | ❌ | ✅ | Postal code for workplace |
varchar | ❌ | ❌ | ✅ | Email address for workplace | |
mobile* | varchar | ❌ | ❌ | ✅ | Mobile number for workplace |
operating | boolean | ❌ | ❌ | ❌ | Shop working or not |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
name | varchar | ❌ | ❌ | ❌ | Name of workplace |
address | varchar | ❌ | ❌ | ✅ | Address of workplace |
city | varchar | ❌ | ❌ | ✅ | City where workplace is located |
postal_code | varchar | ❌ | ❌ | ✅ | Postal code for workplace |
varchar | ❌ | ❌ | ✅ | Email address for workplace | |
mobile* | varchar | ❌ | ❌ | ✅ | Mobile number for workplace |
operating | boolean | ❌ | ❌ | ❌ | Shop working or not |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
shop_id | int | ❌ | ✅ | ❌ | Reference to working hours |
day | varchar | ❌ | ❌ | ❌ | Day in a week |
opening_hours | time | ❌ | ❌ | ✅ | Defines starting hours |
closing_hours | time | ❌ | ❌ | ✅ | Defines closing hours |
working | boolean | ❌ | ❌ | ❌ | Defines if place is open or not |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
name | varchar | ❌ | ❌ | ❌ | Name of company |
address | varchar | ❌ | ❌ | ✅ | Address of company |
city | varchar | ❌ | ❌ | ✅ | City where company is located |
postal_code | varchar | ❌ | ❌ | ✅ | Postal code for company |
varchar | ❌ | ❌ | ✅ | Email address for company | |
telephone | varchar | ❌ | ❌ | ✅ | Mobile number for company |
mobile | varchar | ❌ | ❌ | ✅ | Mobile number for company |
fax | varchar | ❌ | ❌ | ✅ | Fax number for company |
website | varchar | ❌ | ❌ | ✅ | Website of the company |
contact_person | varchar | ❌ | ❌ | ✅ | Company's contact person |
bank_account_number* | varchar | ❌ | ❌ | ✅ | Company's bank account number |
TIN | varchar | ❌ | ❌ | ❌ | TAX Identification Number (PIB) |
UCID | varchar | ❌ | ❌ | ❌ | Unique Company Identification Number (MB) |
taxpayer | boolean | ❌ | ❌ | ❌ | Wether company is in tax system |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
worker_name | varchar | ❌ | ❌ | ✅ | Worker's full name |
visible_name | varchar | ❌ | ❌ | ❌ | Nickname in software |
username | varchar | ❌ | ❌ | ❌ | Worker's username, LOGIN |
password | varchar | ❌ | ❌ | ❌ | Worker's password, LOGIN |
is_admin | boolean | ❌ | ❌ | ❌ | Defines if user has admin privileges |
is_manager | boolean | ❌ | ❌ | ❌ | Defines if user has manager privileges |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
shop_id | int | ❌ | ✅ | ❌ | Reference to shop/workplace |
type_of_pay | int | ❌ | ✅ | ❌ | Type of bill, references to bill type |
issuance_day | date | ❌ | ❌ | ❌ | Day of bill issuance |
due_month | int | ❌ | ❌ | ❌ | Month of debt towards issuer |
due_year | int | ❌ | ❌ | ❌ | Year of debt towards issuer |
cost | double | ❌ | ❌ | ❌ | Amount of due money on bill |
payment_code | int | ❌ | ❌ | ✅ | Payment code |
reference_number | varchar | ❌ | ❌ | ✅ | Unique number connecting payer and issuer |
payer_name | varchar | ❌ | ❌ | ❌ | Name of payer |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
service_name | varchar | ❌ | ❌ | ❌ | Name of the service that bill is referencing to |
service_bank_account_number | varchar | ❌ | ❌ | ✅ | Bank account of bill issuer |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
article_id | int | ❌ | ✅ | ❌ | The reference to article |
inventory_id | int | ❌ | ✅ | ❌ | The reference to specific inventory |
count_number | double | ❌ | ❌ | ❌ | Amount of specific article in inventory |
purchase_price | double | ❌ | ❌ | ❌ | The price for which is that article paid |
selling_margin | double | ❌ | ❌ | ❌ | The percent that increases the price of specific article |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
suplier_id | int | ❌ | ✅ | ❌ | The reference to supplier |
inventory_id | int | ❌ | ✅ | ❌ | The reference to specific inventory |
creation_date | date | ❌ | ❌ | ❌ | Date when we created procurement |
realized | bool | ❌ | ❌ | ❌ | If procurement is done or still filling |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
procurement_id | int | ❌ | ✅ | ❌ | The reference to procurement |
article_id | int | ❌ | ✅ | ❌ | The reference to specific article |
amount_number | double | ❌ | ❌ | ❌ | Order Amount |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
shop_id | int | ❌ | ✅ | ❌ | The reference to procurement |
inventory_id | int | ❌ | ✅ | ❌ | Referencing to inventory |
delivery_date | date | ❌ | ❌ | ❌ | Date when will be delivered |
realized | bool | ❌ | ❌ | ❌ | If delivery is done or still pending |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
shop_id | int | ❌ | ✅ | ❌ | The reference to procurement |
article_id | int | ❌ | ✅ | ❌ | Date when will be delivered |
amount_number | double | ❌ | ❌ | ❌ | Delivery amount |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
name | varchar | ❌ | ❌ | ❌ | Name of company |
address | varchar | ❌ | ❌ | ✅ | Address of company |
city | varchar | ❌ | ❌ | ✅ | City where company is located |
postal_code | varchar | ❌ | ❌ | ✅ | Postal code for company |
varchar | ❌ | ❌ | ✅ | Email address for company | |
telephone | varchar | ❌ | ❌ | ✅ | Mobile number for company |
mobile | varchar | ❌ | ❌ | ✅ | Mobile number for company |
fax | varchar | ❌ | ❌ | ✅ | Fax number for company |
website | varchar | ❌ | ❌ | ✅ | Website of the company |
contact_person | varchar | ❌ | ❌ | ✅ | Company's contact person |
bank_account_number* | varchar | ❌ | ❌ | ✅ | Company's bank account number |
TIN | varchar | ❌ | ❌ | ❌ | TAX Identification Number (PIB) |
UCID | varchar | ❌ | ❌ | ❌ | Unique Company Identification Number (MB) |
taxpayer | boolean | ❌ | ❌ | ❌ | Wether company is in tax system |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
shop_id | int | ❌ | ✅ | ❌ | Reference to shop |
article_id | int | ❌ | ✅ | ❌ | The reference to specific article |
count_number | double | ❌ | ❌ | ❌ | Amount of present articles |
selling_price | double | ❌ | ❌ | ❌ | Price of article per unit |
discount | int | ❌ | ❌ | ✅ | Discount for article price (%) |
expiration_date | date | ❌ | ❌ | ✅ | Expiration date for article |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
worker_id | int | ❌ | ✅ | ✅ | Worker which issued a bill |
shop_id | int | ❌ | ✅ | ❌ | Shop which issued a bill |
buyer_id | int | ❌ | ✅ | ✅ | Referencing to corpo buyer |
reference_number | int | ❌ | ❌ | ❌ | Unique number for a bill |
sum_cash | double | ❌ | ❌ | ✅ | Amount of bill paid with cash |
sum_card | double | ❌ | ❌ | ✅ | Amount of bill paid with a card |
final_sum | double | ❌ | ❌ | ❌ | Final amount of a bill |
money_given | double | ❌ | ❌ | ❌ | Amount of money customer has given |
cash_back | double | ❌ | ❌ | ❌ | Difference between amount due and amount given |
date_time_issued | datetime | ❌ | ❌ | ❌ | Date and time for issued bill |
TAX_amount | double | ❌ | ❌ | ❌ | Amount of money for TAX |
discount_amount | double | ❌ | ❌ | ✅ | Amount of money discounted |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
fiscal_bill_id | int | ❌ | ✅ | ❌ | Reference to bill |
article_id | int | ❌ | ✅ | ❌ | Reference to the article |
amount | double | ❌ | ❌ | ❌ | Amount of article sold |
article_cost | double | ❌ | ❌ | ❌ | Cost of article (after discount, if applicable) |
article_TAX | double | ❌ | ❌ | ❌ | Amount of TAX |
article_discount | double | ❌ | ❌ | ✅ | Amount of discount (in currency) |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
inventory_id | int | ❌ | ✅ | ❌ | Referencing to inventory delivering |
shop_id | int | ❌ | ✅ | ❌ | Referencing to shop ordering |
creation_date | date | ❌ | ❌ | ✅ | Date order has been created |
realized | bool | ❌ | ❌ | ❌ | If order request is ready or still in progress |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
request_id | int | ❌ | ✅ | ❌ | Referencing request order |
article_id | int | ❌ | ✅ | ❌ | Referencing article |
amount_number | double | ❌ | ❌ | ❌ | Amount of article needed |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
corpo_id | int | ❌ | ✅ | ❌ | Referencing company |
worker_id | int | ❌ | ✅ | ✅ | Worker which issued an invoice |
shop_id | int | ❌ | ✅ | ❌ | Shop which issued an invoice |
date_issued | date | ❌ | ❌ | ❌ | Date and time for issued invoice |
payment_dedline | date | ❌ | ❌ | ✅ | Date deadline for payment |
invoice_number | varchar | ❌ | ❌ | ❌ | Unique number for an invoice |
sum_cash | double | ❌ | ❌ | ✅ | Amount of invoice paid with cash |
sum_card | double | ❌ | ❌ | ✅ | Amount of invoice paid with a card |
final_sum | double | ❌ | ❌ | ❌ | Final amount on invoice |
TAX_amount | double | ❌ | ❌ | ❌ | Amount of money for TAX |
discount_amount | double | ❌ | ❌ | ✅ | Amount of money discounted |
invoice_paid | bool | ❌ | ❌ | ❌ | If company has paid invoice |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
invoice_id | int | ❌ | ✅ | ❌ | Reference to invoice |
article_id | int | ❌ | ✅ | ❌ | Reference to the article |
amount | double | ❌ | ❌ | ❌ | Amount of article sold |
article_cost | double | ❌ | ❌ | ❌ | Cost of article (after discount, if applicable) |
article_TAX | double | ❌ | ❌ | ❌ | Amount of TAX |
article_discount | double | ❌ | ❌ | ✅ | Amount of discount (in currency) |
Attribute Name | Data Type | Primary Key | Foreign Key | NULL | Description |
---|---|---|---|---|---|
id | int | ✅ | ❌ | ❌ | Auto-increment value |
corpo_id | int | ❌ | ✅ | ❌ | Referencing company |
shop_id | int | ❌ | ✅ | ❌ | Referencing shop |
fiscal_bill_id | int | ❌ | ✅ | ❌ | Referencing issued bill |
date_time_issued | datetime | ❌ | ❌ | ❌ | Date and time cash bill was issued |