Free cookie consent management tool by TermsFeed Policy Generator

Ignore:
Timestamp:
06/18/13 11:39:31 (10 years ago)
Author:
spimming
Message:

#1888:

  • Users now contain ContactInformation
  • Fixed formatting in invoice template
  • Fixed calculation for next invoice date
  • Worked on indentation for invoice fields
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/OaaS/HeuristicLab.Services.Optimization.Billing.Test/DDLScript.sql

    r9619 r9641  
    7979create table [dbo].[Users] (
    8080    [UserId] [bigint] not null identity,
     81    [ContactInformationId] [bigint] not null,
    8182    [Name] [nvarchar](max) null,
    8283    primary key ([UserId])
     
    9192alter table [dbo].[UsageRecords] add constraint [UsageRecord_Product] foreign key ([ProductId]) references [dbo].[Products]([ProductId]);
    9293alter table [dbo].[UsageRecords] add constraint [UsageRecord_User] foreign key ([UserId]) references [dbo].[Users]([UserId]);
     94alter table [dbo].[Users] add constraint [User_ContactInformation] foreign key ([ContactInformationId]) references [dbo].[ContactInformations]([ContactInformationId]);
    9395alter table [dbo].[PaymentInformations] add constraint [User_PaymentInformation] foreign key ([UserId]) references [dbo].[Users]([UserId]);
Note: See TracChangeset for help on using the changeset viewer.