ODOP

Tables (6)

Bookmark

  • id (Key) — Primary key — NOT NULL
  • user_id (북마크를 누른 유저의 id) — foreign key (post.id)
  • post_id (유저가 북마크를 누른 포스트 id) — foreign key (post.id)
  • Field

Friend (Friends)

  • id (Key) — Primary key — NOT NULL
  • user_a_id (Field)
  • user_b_id (친구관계를 맺은 유저 ID)

Pet

  • id (애완동물의 아이디) — Primary key — NOT NULL
  • name (Field)
  • sex (Field2)
  • age (Field3)

Post

  • id (Key) — Primary key — NOT NULL
  • post image (Field)
  • author (user id)

User

  • user id (Key) — Primary key — NOT NULL
  • password (Field)
  • birth (Field2)
  • birth (Field3)
  • name (Field4)

post_react

  • id (Key) — Primary key — NOT NULL
  • user_id (Field)
  • post_id (Field2)
  • tyoe (enum(like, hate))