---
# System prepended metadata

title: DBMS Fin Project (6/14)

---

# 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/

