241226
Tables (6)
images (Untitled6)
- id (Key) — long — Primary key — NOT NULL
- postId (Key3) — long — Foreign key → post.postId — NOT NULL
- url (Field) — varchar(255)
likes (Untitled2)
- likesId (Key) — long — Primary key — NOT NULL
- user_id (Field5) — long — Foreign key → user.id
- postId (Key3) — Foreign key → post.postId — NOT NULL
- count (Field) — long
main_category (Untitled3)
- main_categoryId (Key) — long — Primary key — NOT NULL
- category_name (Field) — varchar
post (Untitled5)
- postId (Key3) — long — Primary key — NOT NULL
- sub_categoryId (Key2) — long — Foreign key → sub_category.sub_categoryId — NOT NULL
- user_id (Field2) — long — Foreign key → user.id
- main_categoryId (Key) — long — Foreign key → main_category.main_categoryId — NOT NULL
- title (Field) — varchar
- description (Field4) — varchar
- tag1 (Field5) — varchar
- tag2 (Field6) — varchar
- tag3 (Field7) — varchar
- createAt (Field8) — LocalDateTime
- updateAt (Field9) — LocalDateTime
sub_category (Untitled4)
- sub_categoryId (Key) — long — Primary key — NOT NULL
- main_categoryId (Key2) — long — Foreign key → main_category.main_categoryId — NOT NULL
- sub_categoryname (Field) — varchar
user (Untitled)
- id (User 아이디) — long — Primary key
- password (Field2) — varchar
- nickName (varchar) — varchar
- phoneNumber (Field4) — varchar
- birth (Field5) — localdate
- username (Field3) — varchar