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