emiary
Tables (6)
DIARIES
- diary_id — NUMBER(10) — Primary key
- email — VARCHAR2(100) — Foreign key → member.email
- content — CLOB — NOT NULL
- content_notag — CLOB — NOT NULL
- emotionscore — NUMBER(10, 2) — NOT NULL
- created_at — DATE
- keyword — VARCHAR2(20)
- wordsforai — VARCHAR2(200)
- updated_at (—) — DATE
friendship
- email (friend_email) — VARCHAR2(100) — Foreign key → member.email
- email (user_email) — VARCHAR2(100) — Foreign key → member.email
- like_status — VARCHAR2(10) — NOT NULL
- created_at — DATE
member
- email — VARCHAR2(100) — Primary key
- memberpw — 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)
- imgurl — varchar(300)
message
- message_id — NUMBER — Primary key
- content — VARCHAR2(1000) — NOT NULL
- sent_at — DATE
- read_at — DATE
- email (sender_email) — VARCHAR2(100) — Foreign key → member.email
- email (receiver_email) — VARCHAR2(100) — Foreign key → member.email
reply
- reply_id — NUMBER(10) — Primary key
- diary_id — NUMBER(10) — Foreign key → DIARIES.diary_id
- replyContent — VARCHAR2(2000) — NOT NULL
- writer_email — VARCHAR2(100) — NOT NULL
- created_at_reply — date
- smile — varchar(1)
- viewed — varchar(1)
visited
- visited_id — NUMBER(10) — Primary key
- diary_id — NUMBER(10) — Foreign key → DIARIES.diary_id
- visited_email — varchar2(100)
- heart — varchar(1)