search

CAFECA-IO / iSunFA

Artificial Intelligence in Financial
https://isunfa.com
GNU General Public License v3.0
0 stars 0 forks source link

[DOCS] - DB schema modification till next sprint ~2024/11/15 #3159

Open RexBearIU opened 2 weeks ago

RexBearIU commented 2 weeks ago

Summary

DB schema modification till next sprint ~2024/11/15

Tasks

Dependencies

No response

Other Dependencies

No response

Additional Notes

No response

RexBearIU commented 2 weeks ago

companySetting { add country code }

TinyMurky commented 2 weeks ago

Accociate 改成 associate event 裡的 frequence 改成 frequency

RexBearIU commented 1 week ago

account { add note? }

arealclimber commented 1 week ago

companySetting { add country code }

countryCode string @default tw

Accociate 改成 associate event 裡的 frequence 改成 frequency

改 prisma / db 裡的 accociate => associate 改欄位名字 frequence => frequency

account { add note? }

account table 加上 note string 選填欄位

arealclimber commented 1 week ago
arealclimber commented 1 week ago

  1. DB Account table

    1. 改 id 的值

    2. 新增 parentId, rootId 欄位，並且依照 seed.json 去給預設會計科目的 parentId, rootId 的值

    3. 根據規則去給自訂會計科目的 parentId, rootId 的值

    4. 新增 note 選填欄位，格式為 string

    5. 移除 code 的 unique 限制

    6. 修改 parent, child 關係，改用 id 引用

  2. DB CompanySetting table

    1. 新增欄位

      1. countryCode string @default tw

  3. prisma model AccociateLineItem

    1. 改欄位名稱

      1. accociateVoucherId ⇒ associateVoucherId

      2. accociateVoucher ⇒ associateVoucher

  4. prisma model AccociateVoucher

    1. 改欄位名稱

      1. associateLineItems 對應的 AccociateLineItem ⇒ AssociateLineItem

  5. DB AccociateLineItem table

    1. 改欄位名稱

      1. accociate_voucher_id ⇒ associate_voucher_id

  6. DB Event table

    1. 改欄位名稱

      1. frequence ⇒ frequency