dailyhub

Tables (8)

image (imageTable)

  • imageId (Key) — long — Primary key — NOT NULL
  • postId (Key2) — long — Foreign key → post.postId — NOT NULL
  • url (Field4) — varchar

likes (likesTable)

  • likesId (Key) — long — Primary key — NOT NULL
  • userId (Key2) — long — Foreign key → user.userId — NOT NULL
  • postId (Key3) — long — Foreign key → post.postId — NOT NULL

main_category (mainCategoryTable)

  • main_categoryId (Key) — long — Primary key — NOT NULL
  • categoryName (Field) — varchar

post (postTable)

  • postId (Key) — long — Primary key — NOT NULL
  • main_categoryId (Key2) — long — Foreign key → main_category.main_categoryId — NOT NULL
  • sub_categoryId (Key3) — long — Foreign key → sub_category.sub_categoryId — NOT NULL
  • userId (Key4) — long — Foreign key → user.userId — NOT NULL
  • title (Field) — varchar
  • description (Field2) — varchar
  • createAt (Field3) — LocalDateTime
  • updateAt (Field4) — LocalDateTime

postTag (postTagTable)

  • postTagId (Key) — long — Primary key — NOT NULL
  • postId (Key2) — long — Foreign key → post.postId — NOT NULL
  • tagId (Key3) — long — Foreign key → tag.tagId — NOT NULL

sub_category (subCategoryTable)

  • sub_categoryId (Key) — long — Primary key — NOT NULL
  • main_categoryId (Key2) — long — Foreign key → main_category.main_categoryId — NOT NULL
  • categoryName (Field) — varchar

tag (tagTable)

  • tagId (Key) — long — Primary key — NOT NULL
  • name (Field) — varchar

user (userTable)

  • userId (Key) — long — Primary key — NOT NULL
  • password (Field) — varchar
  • nickname (Field2) — varchar
  • phoneNumber (Field3) — varchar
  • birth (Field4) — varchar
  • username (Field5) — varchar