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)