Diary

Tables (3)

DIARYDATA

  • DIARYID — INTEGER — Primary key — NOT NULL
  • TITLE — TEXT
  • CONTENTS — TEXT
  • NEWYMD — DATE
  • LASTYMD — DATE
  • ISEDITED — INTEGER
  • ISREADED — INTEGER
  • ROOMID — INTEGER — Foreign key → DIARYROOM.ROOMID — NOT NULL
  • WRITER (USERID) — TEXT — Foreign key → USERDATA.USERID — NOT NULL

DIARYROOM (DiaryRoom)

  • ROOMID — INTEGER — Primary key — NOT NULL
  • COMMENT — TEXT
  • OPENTIME (TIME) — DATE
  • NEWYMD — DATE
  • LASTYMD — DATE
  • NAME1 — TEXT
  • NAME2 — TEXT
  • WRITER1 (USERID) — TEXT — Foreign key → USERDATA.USERID — NOT NULL
  • WRITER2 (USERID2) — TEXT — Foreign key → USERDATA.USERID — NOT NULL

USERDATA

  • USERID — TEXT — Primary key — NOT NULL
  • NAME — TEXT
  • COMMENT — TEXT
  • NEWYMD — DATE
  • LASTYMD (Field) — DATE