1
Tables (4)
diaries
- diary_id — NUMBER(10) — Primary key
- email — VARCHAR2(100) — Foreign key → users.email
- emotion_id — NUMBER(10) — Foreign key → emotions.emotion_id
- title — VARCHAR2(100)
- content — CLOB — NOT NULL
- written_date — DATE — NOT NULL
- created_at — DATE
- updated_at — DATE
emotions
- emotion_id — NUMBER(10) — Primary key
- name — VARCHAR2(20) — NOT NULL
friend_requests
- request_id — NUMBER(10) — Primary key
- email (requester_id) — VARCHAR2(100) — Foreign key → users.email
- email (requestee_id) — NUMBER(10) — NOT NULL
- status — VARCHAR2(10) — NOT NULL
- created_at — DATE
users
- email — VARCHAR2(100) — Primary key
- password — VARCHAR2(100) — NOT NULL
- nickname — VARCHAR2(50) — NOT NULL
- phone — VARCHAR2(20) — NOT NULL
- birthdate — DATE — NOT NULL
- created_at — DATE
- updated_at — DATE
- profile_visibility — VARCHAR2(1) — NOT NULL
- chat_rejection — VARCHAR2(1) — NOT NULL
- enabled — NUMBER(1)
- rolename — VARCHAR2(20)