emiary

Tables (5)

diaries

  • diary_id — NUMBER(10) — Primary key
  • email — VARCHAR2(100) — Foreign key → users.email
  • title — VARCHAR2(100)
  • content — BLOB — NOT NULL
  • written_date — DATE — NOT NULL
  • created_at — DATE
  • updated_at — DATE
  • emotion_id — NUMBER(10)
  • Field

emotions

  • emotion_id — NUMBER(10) — Primary key
  • diary_id — NUMBER(10) — Foreign key → diaries.diary_id
  • email — VARCHAR2(100) — Foreign key → diaries.email
  • 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) — VARCHAR2(100) — NOT NULL
  • status — VARCHAR2(10) — NOT NULL
  • created_at — DATE

friends

  • friendship_id — NUMBER(10) — Primary key
  • email (user_id) — VARCHAR2(100) — Foreign key → users.email
  • email (friend_id) — NUMBER(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)