mall

Tables (6)

Member (member)

  • email — varchar(255) — Primary key — NOT NULL
  • pw — varchar(255)
  • nickname — varchar(255)
  • social — bit(1)

Member (document_member)

  • email — varchar — Primary key — NOT NULL
  • pw — varchar
  • nickname — varchar
  • social — boolean
  • memberRoleList (memberRolerList) — enum[]

MemberRole (member_member_role_list)

  • email — varchar(255) — Foreign key → Member.email — NOT NULL
  • member_role_list — tinyint

Todo (tbl_todo)

  • tno — bigint — Primary key — NOT NULL
  • email — varchar(255) — Foreign key → Member.email — NOT NULL
  • title — varchar(500)
  • content — varchar(255)
  • completec (complete) — bit(1)
  • dueDate — date

Todo (document_todo)

  • id — objectId — Primary key — NOT NULL
  • title — varchar
  • content — varchar
  • complete — boolean
  • dueDate — date
  • memberEmail — varchar
  • imageList — struct[]

TodoImage (todo_image_list)

  • tno — bigint — Foreign key → Todo.tno — NOT NULL
  • filename — varchar(255)
  • ord — int