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