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 (최종수정일)