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