thing
Tables (9)
MemberDiary (Untitled5)
- memberId (Key) — String — Foreign key → member.memberId — NOT NULL
- diaryId (Key2) — INT — Foreign key → diary.diaryId — NOT NULL
MemberMemo (Untitled3)
- memberId (Key) — String — Foreign key → member.memberId — NOT NULL
- MemoId (Key2) — INT — Foreign key → memo.MemoId — NOT NULL
addressbook (Untitled8)
- AddressId (Key) — INT — Primary key — NOT NULL
- teamMemberName (Field) — String
- project (Field2) — String
- realization (Field3) — text
diary (Untitled4)
- diaryId (Key) — INT — Primary key — NOT NULL
- main_text (Field) — text — NOT NULL
- edit_time (Field2) — datetime — NOT NULL
- title (Field3) — varchar(255)
member (Untitled)
- memberId (Key) — String — Primary key — NOT NULL
- name (Field) — String — NOT NULL
- pwd (Field3) — String
member to do list (Untitled7)
- memberId (Key) — String — Foreign key → member.memberId — NOT NULL
- listId (Key2) — INT — Foreign key → todolist.listId — NOT NULL
memberAddressbook (Untitled9)
- AddressId (Key) — Int — Foreign key → addressbook.AddressId — NOT NULL
- memberId (Key2) — String — Foreign key → member.memberId — NOT NULL
memo (Untitled2)
- MemoId (Key) — num — Primary key — NOT NULL
- main_text (Field) — text
- edit_time (Field2) — datetime
todolist (Untitled6)
- listId (Key) — INT — Primary key — NOT NULL
- title (Field) — varchar(255) — NOT NULL
- description (Field2) — text
- Deadline (Field3) — date
- isComplete (Field4) — boolean — NOT NULL