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