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