Timeline

Tables (8)

Article Entity (게시글 객체)

  • userID (Key) — varchar2 — Primary key — NOT NULL
  • content (Field) — varchar2
  • photo (Field2) — varchar2
  • video (Field3) — varchar2

Comment Entity (코멘트 객체)

  • id (Key) — varchar2 — Primary key — NOT NULL
  • articleID (Field) — varchar2
  • userID (Field2) — varchar2
  • content (Field3) — varchar2
  • createdtime (Field4) — date

FriendRelationship Entity (친구관계 객체)

  • relationNumber (Key3) — number — Primary key — NOT NULL
  • userID1 (Key) — NOT NULL
  • userID2 (Key2) — NOT NULL

Liked Entity (좋아요 객체)

  • userID (Key) — varchar2 — Primary key — NOT NULL
  • articleID (Key2) — varchar2 — Primary key — NOT NULL

UserEntity (유저 객체)

  • userId (Key) — varchar2 — Primary key — NOT NULL
  • email (Field) — varchar2
  • username (Field2) — varchar2
  • password (Field3) — varchar2
  • question (Field4) — varchar2
  • answer (Field5) — varchar2
  • profile (Field6) — varchar2

articleResponse (게시글 반응)

  • articleID (Key) — varchar2 — Primary key — NOT NULL
  • userId (Key2) — varchar2 — Primary key — NOT NULL
  • username (Field) — varchar2
  • profile (Field2) — varchar2
  • content (Field3) — varchar2
  • photo (Field4) — varchar2
  • like (Field5) — number
  • liked (Field6) — number
  • createdtime (Field7) — date

commentResponse (코멘트 반응)

  • commentID (Key) — varchar2 — Primary key — NOT NULL
  • articleID (Key2) — varchar2 — Primary key — NOT NULL
  • userID (Key3) — varchar2 — Primary key — NOT NULL
  • username (Field) — varchar2
  • profile (Field2) — varchar2
  • content (Field3) — varchar2
  • createdtime (Field4) — date

userResponse (유저 반응)

  • id (Key) — varchar2 — Primary key — NOT NULL
  • email (Field) — varchar2
  • username (Field2) — varchar2
  • profile (Field3) — varchar2