diary
Tables (3)
Diary
- id (PK) — BIGINT — Primary key — NOT NULL
- userid (FK) — BIGINT — Primary key — NOT NULL
- dtitle — VARCHAR2(30) — NOT NULL
- dcontent — CLOB — NOT NULL
- createAt — DATE
- updateAt — DATE
- visibility — VARCHAR2(10)
- dlike — NUMBER
- emo1 — NUMBER
- emo2 — NUMBER
- emo3 — NUMBER
- emo4 — NUMBER
- weather1 — NUMBER
- weather2 — NUMBER
- weather3 — NUMBER
- weather4 — NUMBER
Likes
- Id (PK) — BIGINT — Primary key — NOT NULL
- userId (FK) — BIGINT — Primary key — NOT NULL
- diaryId (fk) — BIGINT — Primary key — NOT NULL
Photo
- id (PK) — BIGINT — Primary key — NOT NULL
- diaryId (FK) — BIGINT — Primary key — NOT NULL
- photoUrl — VARCHAR2(255) — NOT NULL