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 — 나이