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