Algonara

Tables (6)

Comment

  • commentId (Key) — Long — Primary key — NOT NULL
  • courseId (Key2) — Long — Foreign key → Course.courseId — NOT NULL
  • usersId (Key22) — Long — Foreign key → Course.usersId — NOT NULL
  • comment (Field)

Course

  • courseId (Key) — Long — Primary key — NOT NULL
  • usersId (Key2) — Long — Foreign key → Users.usersId — NOT NULL
  • courseTitle (Field) — String
  • courseGrade (Field2) — String
  • courseTime (Field3) — int
  • courseIntro (Field4) — String
  • courseThumbNail (Field5) — String
  • courseTeacher (Field6) — String
  • courseIntroImageUrl (Field7) — String
  • courseCategory (Field8) — String
  • courseVideoUrl (Field9) — String
  • coursePrice (Field10) — int

Product

  • productId (Key) — Long — Primary key — NOT NULL
  • productName (Field) — String
  • productTitle (Field2) — String
  • productImageUrl (Field3) — String
  • productPrice (Field4) — int
  • productCategory (Field5) — String
  • productDesc (Field6) — String
  • delivery (Field7) — String
  • deliveryFee (Field8) — int

ProductCart

  • productCartId (Key) — Long — Primary key — NOT NULL
  • usersId (Key2) — Long — Foreign key → Users.usersId — NOT NULL
  • productId (Key3) — Long — Foreign key → Product.productId — NOT NULL
  • productQuantity (Field) — int

ProductContent

  • ProductContentId (Key) — Long — Primary key — NOT NULL
  • productId (Key2) — Long — Foreign key → Product.productId — NOT NULL
  • productImageUrl (Field) — String

Users

  • usersId (Key) — Long — Primary key — NOT NULL
  • userEmail (Field) — String
  • userId (Field2) — String
  • userName (Field3) — String
  • code (Field4) — String
  • password (Field5) — String
  • policy (Field6) — boolean
  • refreshToken (Field7) — String