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))