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