sns
Tables (11)
Chat
- no — Primary key — NOT NULL
- Room_no — Foreign key → RoomInfo.no — NOT NULL
- no (no2) — Foreign key → RoomInfo.Room_no — NOT NULL
- Content
- date
- name
Follower
- follower_id — Primary key — NOT NULL
- user_id — Foreign key → User.id — NOT NULL — id
Following
- following_id — Primary key — NOT NULL
- user_id — Foreign key → User.id — NOT NULL — id
Posts
- no — Primary key — NOT NULL
- user_id — Foreign key → User.id — NOT NULL — id
- name
- date
- contents
- img — 이미지링크
- video — 영상링크
- delYN — 삭제YN
- public — 공개범위
- like
QnA
- id — Foreign key → User.id — NOT NULL — id
- question
- answer
- day
- public
Room
- no — Primary key — NOT NULL
- name
RoomInfo
- no — Primary key — NOT NULL
- Room_no — Foreign key → Room.no — NOT NULL
- id
- delYN
Tag
- no — Primary key — NOT NULL
- posts_no — Foreign key → Posts.no — NOT NULL
- user_id — Foreign key → Posts.user_id — NOT NULL — id
- contents
User
- id — Primary key — NOT NULL — id
- pw
- email
- link
- name
- photo
comment (Comment)
- no — Primary key — NOT NULL
- posts_no — Foreign key → Posts.no — NOT NULL
- user_id — Foreign key → Posts.user_id — NOT NULL — id
- id
- contents
- delYN
- like
oauthid
- id — Primary key — NOT NULL
- token
- version
- provider
- user_id — Foreign key → User.id — NOT NULL