emoji_db

Tables (5)

Diary (일기)

  • id (일기번호) — serial — Primary key — NOT NULL
  • diary_writer (일기작성자) — bigint — Foreign key → Users.id — NOT NULL
  • emoji_mood (이모지(기분)) — varchar — Foreign key → Emoji_mood.emoji_id — NOT NULL
  • emoji_weather (이모지(날씨)) — varchar — Foreign key → Emoji_weather.emoji_id — NOT NULL
  • emoji_people (이모지(사람)) — varchar — Foreign key → Emoji_people.emoji_id — NOT NULL
  • diary_title (일기제목) — varchar
  • diary_content (일기내용) — varchar
  • diary_image (사진) — varchar
  • diary_date (수정일) — varchar

Emoji_mood (기분)

  • emoji_id (이모지번호) — varchar — Primary key — NOT NULL
  • emoji_name (이모지이름) — varchar

Emoji_people (만난사람)

  • emoji_id (이모지번호) — varchar — Primary key — NOT NULL
  • emoji_name (이모지이름) — varchar

Emoji_weather (날씨)

  • emoji_id (이모지번호) — varchar — Primary key — NOT NULL
  • emoji_name (이모지이름) — varchar

Users (유저)

  • id (회원번호) — serial — Primary key — NOT NULL
  • user_id (유저id) — varchar
  • user_pw (유저pw) — varchar
  • user_name (유저명) — varchar
  • user_nickname (유저닉네임) — varchar
  • user_link (유저링크)