Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Need help with naming a couple of tables Expand / Collapse
Posted Wednesday, January 8, 2014 1:39 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 9:54 AM
Points: 80, Visits: 140
I have this situation where an invoice comes in today with

inv123 01/08/2014 10 $100.

If there is a resubmission of say one line (out of the original 10 lines) tomorrow, the record will come in as

inv123 01/08/2014 1 $20. (note: the invoiceID and invoiceDt remain the same).

So I plan to split this into two tables. The first one will have the ID and Dt. The second one will have the processedDt, lineCnt and totalAmt with a one to many between the first and second tables.

What will be an ideal naming for these two tables. I did not want to call them, invoiceHeader and invoiceDetail as the second one is not actually a detail of the first.

Any suggestions are greatly appreciated.

Post #1529090
Posted Monday, March 24, 2014 11:26 AM


Group: General Forum Members
Last Login: Yesterday @ 3:07 AM
Points: 498, Visits: 757

Googlefor: Data Vault

Post #1554162
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse