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 (유저링크)