# DBMS Fin Project (6/14)

---

[TOC]

---

:::info
## TODO
- 說明文件
- README
- Delete logic
- Null member_id meaning
- View
- proposal deactivated handle
- parameter check
- error message
:::

:::info
## Sheets
- https://docs.google.com/spreadsheets/d/1dvxgZnmxOsx88zlcTkDJIrlTVNuriHIMoKd3o29lm1M/edit?usp=sharing
:::

---

## Entities
- Member
- member_id (int)
- name (varchar(64))
- phone (varchar(64))
- email (varchar(64))
- salt (char(64))
- address (varchar(255))
- MemberCredential
- id
- hashed_user_id
- hashed_pwd_string (varchar(200))
- Proposal
- id (int)
- category_id (int)
- title (varchar(120))
- content (TEXT)
- amount
- goal (int)
- status (int)
- viewed_num
- create_date
- due_date
- is_deactivated
- ProposalOption
- id
- proposal_id (int)
- title
- price
- description
- Comment
- id
- proposal_id (int)
- member_id (int)
- user_comment
- proposer_response
- FAQ
- id
- proposal_id (int)
- last_editor_id
- question
- answer
- updated_at
- SponsorRecord
- id
- member_id (int)
- proposal_option_id
- amount
- FollowingRecord
- id
- proposal_id (int)
- member_id (int)
- ProposalMember
- id
- proposal_id (int)
- member_id (int)
- Category
- id (int)
- category_name

## Refs
- https://medium.com/@centizennationwide/mysql-naming-conventions-e3a6f6219efe
- https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
- https://opensource.actionsky.com/20190802-mysql/