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