emiary
Tables (6)
DIARIES
- diary_id — NUMBER(10) — Primary key
- email — VARCHAR2(100) — NOT NULL
- 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
- Key — Primary key — NOT NULL
- user_email — VARCHAR2(100) — NOT NULL
- friend_email — VARCHAR2(100) — NOT NULL
- like_status — VARCHAR2(10) — NOT NULL
- created_at — DATE
member
- email — VARCHAR2(100) — Primary key
- Key — Foreign key → friendship.Key — NOT NULL
- 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
- sender_email — VARCHAR2(100) — NOT NULL
- receiver_email — VARCHAR2(100) — NOT NULL
- content — VARCHAR2(1000) — NOT NULL
- sent_at — DATE
- read_at — DATE
reply
- reply_id — NUMBER(10) — Primary key
- diary_id — NUMBER(10)
- 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)
- visited_email — varchar2(100)
- heart — varchar(1)