Skip to content

Instantly share code, notes, and snippets.

@VirtueMe

VirtueMe/Definition for complex table

Created October 21, 2010 06:33
Show Gist options
  • Save VirtueMe/638057 to your computer and use it in GitHub Desktop.
Save VirtueMe/638057 to your computer and use it in GitHub Desktop.
Download ZIP
This is the table I want to read with fluentnHibernate
Raw
Definition for complex table
CREATE TABLE [dbo].[TF_MISSION_CODE_CENTRAL_DISCOUNT](
[TF_MISSION_CODE_CENTRAL_DISCOUNT_ID] [int] IDENTITY(1,1) NOT NULL, -- Not Really needed
-- Composite Key start
[TF_CENTRAL_ID] [int] NOT NULL,
[TF_MISSION_CODE_ID] [int] NOT NULL,
-- Composite Key end
-- Period start <== Natural hash key/bag index
[TF_MISSION_CODE_CENTRAL_DISCOUNT_DATE_FROM] [datetime] NOT NULL,
[TF_MISSION_CODE_CENTRAL_DISCOUNT_DATE_TO] [datetime] NULL,
-- Period end
-- Data Component
[TF_MISSION_CODE_CENTRAL_DISCOUNT_ARRIVAL] [money] NULL,
[TF_MISSION_CODE_CENTRAL_DISCOUNT_WAITTIME] [money] NULL,
[TF_MISSION_CODE_CENTRAL_DISCOUNT_AMOUNT_HOUR] [money] NULL,
[TF_MISSION_CODE_CENTRAL_DISCOUNT_KM] [money] NULL,
[TF_MISSION_CODE_CENTRAL_DISCOUNT_PRICE] [money] NULL,
[TF_MISSION_CODE_CENTRAL_DISCOUNT_MINIMUM] [bit] NULL,
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment