Emolog
Tables (7)
Color
- color_id — bigint — Primary key — NOT NULL — 구분자
- red — int — NOT NULL — 빨강
- green — int — NOT NULL — 초록
- blue — int — NOT NULL — 파랑
- hexa — varchar — NOT NULL — 색깔 헥사코드
- diary_id — bigint — Foreign key → Diary.diary_id — NOT NULL — 구분자
Diary
- diary_id — bigint — Primary key — NOT NULL — 구분자
- content — varchar — NOT NULL — 내용
- date — datetime — NOT NULL — 날짜
- users_id — varchar — Foreign key → Users.users_id — NOT NULL — 구분자
Emotion
- emo_id — bigint — Primary key — NOT NULL — 구분자
- emotion — varchar — NOT NULL — 감정
- diary_id — bigint — Foreign key → Diary.diary_id — NOT NULL — 구분자
Job
- job — enum — Primary key — NOT NULL
- student — varchar — NOT NULL — 학생
- office — varchar — NOT NULL — 직장인
- none — varchar — 무직
- users_id — varchar — Foreign key → Users.users_id — NOT NULL — 구분자
Picture
- pic_id — bigint — Primary key — NOT NULL — 구분자
- url — varchar — NOT NULL — 사진 url
- diary_id — bigint — Foreign key → Diary.diary_id — NOT NULL — 구분자
Q_A
- qa_id — bigint — Primary key — NOT NULL — 구분자
- quetion (question) — varchar — NOT NULL — 질문
- answer — varchar — NOT NULL — 답변
- diary_id — bigint — Foreign key → Diary.diary_id — NOT NULL — 구분자
Users (Users)
- users_id — bigint — Primary key — NOT NULL — 구분자
- email — varchar — NOT NULL — 이메일
- name — varchar — NOT NULL — 이름
- login_type — varchar — NOT NULL — 로그인 타입(카카오,구글)
- nickname — varchar — NOT NULL — 닉네임
- age — int — 나이