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