RdsDiagram
users
id: INTEGER
login: VARCHAR(20)
password: VARCHAR(20)
firstname: VARCHAR(100)
lastname: VARCHAR(100)
phone: VARCHAR(20)
email: VARCHAR(100)
country: VARCHAR(50)
city: VARCHAR(50)
zip: INTEGER
address: VARCHAR(255)
gender: BOOLEAN
updated_at: TIMESTAMP
created_at: TIMESTAMP
products
id: INTEGER
product_name: VARCHAR(100)
product_SKU: VARCHAR(20)
product_description: VARCHAR(255)
product_content: VARCHAR(10000)
product_media: INTEGER
product_price: DECIMAL(10,2)
product_views: INTEGER
product_discount: DECIMAL(10,2)
updated_at: TIMESTAMP
created_at: TIMESTAMP
created_by: INTEGER
categories
id: INTEGER
category_name: VARCHAR(50)
category_description: VARCHAR(255)
created_by: INTEGER
updated_at: TIMESTAMP
created_at: TIMESTAMP
product_category
id: INTEGER
created_by: INTEGER
product_id: INTEGER
category_id: INTEGER
updated_at: TIMESTAMP
created_at: TIMESTAMP
orders
id: INTEGER
user_id: INTEGER
orders_note: VARCHAR(500)
orders_status: INTEGER
updated_at: TIMESTAMP
created_at: TIMESTAMP
basket
id: INTEGER
orders_id: INTEGER
product_id: INTEGER
basket_quantity: SMALLINT
basket_price: DECIMAL(10,2)
updated_at: TIMESTAMP
created_at: TIMESTAMP
transactions
id: INTEGER
user_id: INTEGER
orders_id: INTEGER
pay_system_id: INTEGER
transaction_pay_summ: DECIMAL(10,2)
transaction_pay_system_message: VARCHAR(100)
transaction_type: BOOLEAN
transaction_status: SMALLINT
updated_at: TIMESTAMP
created_at: TIMESTAMP
rolls
id: INTEGER
roll_name: VARCHAR(255)
roll_status: BOOLEAN
updated_at: TIMESTAMP
created_at: TIMESTAMP
stock
id: INTEGER
product_id: INTEGER
stock_reserve: INTEGER
stock_avaible: INTEGER
updated_at: TIMESTAMP
created_at: TIMESTAMP
reviews
id: INTEGER
review_rating: SMALLINT
review_description: VARCHAR(255)
rreview_status: BOOLEAN
created_by: INTEGER
updated_at: TIMESTAMP
created_at: TIMESTAMP
pay_systems
id: INTEGER
pay_system_name: VARCHAR(20)
pay_system_status: BOOLEAN
updated_at: TIMESTAMP
created_at: TIMESTAMP
created_by: INTEGER