Column Name | Type | Description |
---|---|---|
id | VARCHAR | Primary Key |
name | VARCHAR | Name of the user |
VARCHAR | Email of the user | |
lat | FLOAT | Latitude of the user |
long | FLOAT | Longitude of the user |
createdAt | TIMESTAMP | Time when the user was created |
updatedAt | TIMESTAMP | Time when the user was last updated |
Column Name | Type | Description |
---|---|---|
merchant_id | VARCHAR | Primary Key |
merchant_name | VARCHAR | Name of the merchant |
geo_loc | GEOGRAPHY | Latitude/Longitude of the merchant |
createdAt | TIMESTAMP | Time when the merchant was created |
updatedAt | TIMESTAMP | Time when the merchant was last updated |
Column Name | Type | Description |
---|---|---|
item_id | VARCHAR | Primary Key |
merchant_id | VARCHAR | Foreign Key referencing merchant_id in merchants table |
name | VARCHAR | Name of the item |
category | VARCHAR | Category of the item |
price | FLOAT | Base selling price of the item |
created_at | TIMESTAMP | Time when the item was created |
updated_at | TIMESTAMP | Time when the item was last updated |
Column Name | Type | Description |
---|---|---|
promotion_id | VARCHAR | Primary Key |
product_id | VARCHAR | Name of the item to which promotion is applied |
discount | FLOAT | Percentage discount applied to the item |
created_at | TIMESTAMP | Time when the promotion was created |
updated_at | TIMESTAMP | Time when the promotion was last updated |
Column Name | Type | Description |
---|---|---|
inventory_id | SERIAL | Primary Key |
merchant_id | INT | Foreign Key referencing merchant_id in merchants table |
item_id | INT | Foreign Key referencing item_id in items table |
qty | INT | Quantity of the item in inventory |
date_acquired | DATE | Date when the item was acquired |
cost | DECIMAL | Cost price of the item |
created_at | TIMESTAMP | Time when the inventory record was created |
updated_at | TIMESTAMP | Time when the inventory record was last updated |
Column Name | Type | Description |
---|---|---|
order_id | SERIAL | Primary Key |
customer_id | INT | Foreign Key referencing user_id in users table |
store_id | INT | Foreign Key referencing merchant_id in merchants table |
date | TIMESTAMP | Date and time of the order |
created_at | TIMESTAMP | Time when the order was created |
updated_at | TIMESTAMP | Time when the order was last updated |
Column Name | Type | Description |
---|---|---|
order_item_id | SERIAL | Primary Key |
order_id | INT | Foreign Key referencing order_id in orders table |
product_id | INT | Foreign Key referencing item_id in items table |
qty | INT | Quantity of the item in the order |
created_at | TIMESTAMP | Time when the order item was created |
updated_at | TIMESTAMP | Time when the order item was last updated |