MOY

Tables (4)

Diary (일기)

  • id (아이디) — Primary key — NOT NULL
  • email (이메일) — Foreign key → User.email — NOT NULL
  • title (제목)
  • public (공개 여부) — Boolean
  • content (내용)
  • CreateDate (작성일)
  • LastModified (수정일)

Follow (팔로우)

  • id — Primary key — NOT NULL
  • Follower_id (팔로워) — Foreign key → User.user_id — NOT NULL
  • Following_id (팔로잉) — Foreign key → User.user_id — NOT NULL

Report (감정평가)

  • report_id (아이디) — Primary key — NOT NULL
  • diary_id (아이디2) — Foreign key → Diary.id — NOT NULL
  • Score (점수)
  • Contents (내용)
  • CreateDate (작성일)
  • LastModified (수정일)

User (유저)

  • user_id (아이디) — Primary key — NOT NULL
  • email (이메일) — Primary key — NOT NULL
  • password (패스워드)
  • name (이름)
  • roles (권한)
  • RegisterDate (가입일)
  • LastModified (최종수정일)