createTable.sql

USE [CoaterLiveProcess]
GO

/****** Object:  Table [dbo].[Lot]    Script Date: 6/1/2016 8:49:00 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Lot](
	[LotNo] [int] NOT NULL,
	[FlowScheduleNo] [int] NOT NULL,
	[Side] [char](1) NULL,
	[Time] [datetime] NOT NULL,
	[GridId] [int] NULL,
	[Coater] [smallint] NULL,
 CONSTRAINT [PK_Lot] PRIMARY KEY CLUSTERED 
(
	[LotNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Lot]  WITH CHECK ADD  CONSTRAINT [FK_Lot_FlowSchedule] FOREIGN KEY([FlowScheduleNo])
REFERENCES [dbo].[FlowSchedule] ([FlowScheduleNo])
GO

ALTER TABLE [dbo].[Lot] CHECK CONSTRAINT [FK_Lot_FlowSchedule]
GO

DataClasses1.dbml

<?xml version="1.0" encoding="utf-8"?><Database Name="CoaterLiveProcess" Class="DataClasses1DataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
  <Connection Mode="AppSettings" ConnectionString="Data Source=zvm-mesdevsql2;Initial Catalog=CoaterLiveProcess;Integrated Security=True" SettingsObjectName="ConsoleApplication4.Properties.Settings" SettingsPropertyName="CoaterLiveProcessConnectionString" Provider="System.Data.SqlClient" />
  <Table Name="dbo.[Check]" Member="Checks">
    <Type Name="Check">
      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="Name" Type="System.String" DbType="NChar(32) NOT NULL" CanBeNull="false" />
      <Column Name="Description" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
    </Type>
  </Table>
  <Table Name="dbo.Color" Member="Colors">
    <Type Name="Color">
      <Column Name="ID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="LotNo" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Alpha" Type="System.String" DbType="VarChar(5) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Y" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="L" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="a" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="b" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="Wave" Type="System.Double" DbType="Float" CanBeNull="true" />
      <Column Name="WaveInvalid" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Association Name="Lot_Color" Member="Lot" ThisKey="LotNo" OtherKey="LotNo" Type="Lot" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.TRA" Member="TRAs">
    <Type Name="TRA">
      <Column Name="ID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="LotNo" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Alpha" Type="System.String" DbType="VarChar(5) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Transmission" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="Reflection" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="Absorption" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="NonECTransmission" Type="System.Double" DbType="Float" CanBeNull="true" />
      <Association Name="Lot_TRA" Member="Lot" ThisKey="LotNo" OtherKey="LotNo" Type="Lot" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.FlowSchedule" Member="FlowSchedules">
    <Type Name="FlowSchedule">
      <Column Name="FlowScheduleNo" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="PartNumber" Type="System.String" DbType="VarChar(20) NOT NULL" CanBeNull="false" />
      <Column Name="Coater" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Association Name="FlowSchedule_Lot" Member="Lots" ThisKey="FlowScheduleNo" OtherKey="FlowScheduleNo" Type="Lot" />
    </Type>
  </Table>
  <Table Name="dbo.Haze" Member="Hazes">
    <Type Name="Haze">
      <Column Name="ID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="LotNo" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Alpha" Type="System.String" DbType="VarChar(5) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Haze" Member="Haze1" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Association Name="Lot_Haze" Member="Lot" ThisKey="LotNo" OtherKey="LotNo" Type="Lot" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Lot" Member="Lots">
    <Type Name="Lot">
      <Column Name="LotNo" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="FlowScheduleNo" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="Side" Type="System.Char" DbType="Char(1)" CanBeNull="true" />
      <Column Name="Time" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="GridId" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Coater" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Association Name="Lot_Color" Member="Colors" ThisKey="LotNo" OtherKey="LotNo" Type="Color" />
      <Association Name="Lot_TRA" Member="TRAs" ThisKey="LotNo" OtherKey="LotNo" Type="TRA" />
      <Association Name="Lot_Haze" Member="Hazes" ThisKey="LotNo" OtherKey="LotNo" Type="Haze" />
      <Association Name="Lot_Ohm" Member="Ohms" ThisKey="LotNo" OtherKey="LotNo" Type="Ohm" />
      <Association Name="Lot_Spectrum" Member="Spectrums" ThisKey="LotNo" OtherKey="LotNo" Type="Spectrum" />
      <Association Name="FlowSchedule_Lot" Member="FlowSchedule" ThisKey="FlowScheduleNo" OtherKey="FlowScheduleNo" Type="FlowSchedule" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Ohm" Member="Ohms">
    <Type Name="Ohm">
      <Column Name="ID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="LotNo" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Alpha" Type="System.String" DbType="VarChar(5) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Ohms" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Association Name="Lot_Ohm" Member="Lot" ThisKey="LotNo" OtherKey="LotNo" Type="Lot" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Spectrum" Member="Spectrums">
    <Type Name="Spectrum">
      <Column Name="ID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="LotNo" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Alpha" Type="System.String" DbType="VarChar(5) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="[360]" Member="_360" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[370]" Member="_370" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[380]" Member="_380" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[390]" Member="_390" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[400]" Member="_400" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[410]" Member="_410" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[420]" Member="_420" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[430]" Member="_430" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[440]" Member="_440" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[450]" Member="_450" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[460]" Member="_460" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[470]" Member="_470" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[480]" Member="_480" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[490]" Member="_490" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[500]" Member="_500" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[510]" Member="_510" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[520]" Member="_520" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[530]" Member="_530" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[540]" Member="_540" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[550]" Member="_550" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[560]" Member="_560" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[570]" Member="_570" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[580]" Member="_580" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[590]" Member="_590" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[600]" Member="_600" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[610]" Member="_610" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[620]" Member="_620" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[630]" Member="_630" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[640]" Member="_640" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[650]" Member="_650" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[660]" Member="_660" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[670]" Member="_670" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[680]" Member="_680" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[690]" Member="_690" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[700]" Member="_700" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[710]" Member="_710" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[720]" Member="_720" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[730]" Member="_730" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[740]" Member="_740" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Column Name="[750]" Member="_750" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
      <Association Name="Lot_Spectrum" Member="Lot" ThisKey="LotNo" OtherKey="LotNo" Type="Lot" IsForeignKey="true" />
    </Type>
  </Table>
</Database>