[dbo].[AdvanceTransmission]

Property	Value
Row Count (~)	0
Created	7:30:31 PM Wednesday, February 28, 2024
Last Modified	7:30:41 PM Wednesday, February 28, 2024

Property

Value

Row Count (~)

Created

7:30:31 PM Wednesday, February 28, 2024

Last Modified

7:30:41 PM Wednesday, February 28, 2024

Name	Data Type	Max Length (Bytes)	Identity
AdvanceTransmissionID	int	4	1 - 1
CreatedByFID	int	4
CreatedOn	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

AdvanceTransmissionID

int

1 - 1

CreatedByFID

int

CreatedOn

datetime

	Name	Columns	Unique
	PK_AdvanceTransmission	AdvanceTransmissionID

Name

Columns

Unique

PK_AdvanceTransmission

AdvanceTransmissionID

Name	Columns
FK_AdvanceTransmission_Sysuser	CreatedByFID->[dbo].[Sysuser].[SysUserID]

Name

Columns

FK_AdvanceTransmission_Sysuser

CreatedByFID->[dbo].[Sysuser].[SysUserID]

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

Type

Action

Owning Principal

Grant

Delete

MssExec

Grant

Insert

MssExec

Grant

Select

MssExec

Grant

Update

MssExec

SQL Script

CREATE TABLE [dbo].[AdvanceTransmission]
(
[AdvanceTransmissionID] [int] NOT NULL IDENTITY(1, 1),
[CreatedByFID] [int] NOT NULL,
[CreatedOn] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdvanceTransmission] ADD CONSTRAINT [PK_AdvanceTransmission] PRIMARY KEY CLUSTERED  ([AdvanceTransmissionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdvanceTransmission] ADD CONSTRAINT [FK_AdvanceTransmission_Sysuser] FOREIGN KEY ([CreatedByFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
GRANT SELECT ON  [dbo].[AdvanceTransmission] TO [MssExec]
GRANT INSERT ON  [dbo].[AdvanceTransmission] TO [MssExec]
GRANT DELETE ON  [dbo].[AdvanceTransmission] TO [MssExec]
GRANT UPDATE ON  [dbo].[AdvanceTransmission] TO [MssExec]
GO