- Tablolar - Branch - branchId -> PK - Customer - customerId -> PK - Account - accountId -> PK - customer ve account tablosu arasında 1-n ilişki bulunur -> FK - Address - addressId -> PK - customer ve address tablosu arasında 1-n ilişki bulunur -> FK - Contract - contractId -> PK - customer ve contract tablosu arasında 1-n ilişki bulunur -> FK
- status -> A veya P
- version -> 1’den başlar
- createdDate -> Tarih/Saat
- modifiedDate -> Tarih/Saat
-
SP’ler
- Branch save, update, get, list, delete
- Customer save, update, get, list, delete
- Account save, update, get, list, delete
- Contract save, update, get, list, delete
-
Endpoint’ler
- branches/
- customers/
- customers/(customerId)/address
- customers/(customerId)/contracts
-