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