boost_db
Tables (3)
OrderTable (user_order)
- OrderNumber (ono) — bigint — Primary key — NOT NULL
- OrderValue (o_value) — varchar(100)
- OrderCreatedAt (o_created_at) — datetime
- UserNumber (uno) — bigint — Foreign key → UserTable.UserNumber — NOT NULL
ProductTale (product)
- ProductNumber (pno) — bigint — Primary key — NOT NULL
- ProductName (p_name) — varchar(100)
- ProductDesc (p_desc) — varchar(100)
- ProductPrice (p_price) — int
- ProductCount (p_count) — int
- ProductCompany (p_company) — varchar(100)
UserTable (user)
- UserNumber (uno) — bigint — Primary key — NOT NULL
- UserEmail (email) — varchar(100)
- UserName (name) — varchar(50)
- UserPassword (password) — varchar(500)
- UserCreatedAt (created_at) — datetime
- UserLastLogin (last_login) — datetime