CREATE TABLE [LAFCMS_association] (
	[association_id] [char] (26) NOT NULL ,
	[associated_id_a] [char] (26) NULL ,
	[associated_id_b] [char] (26) NULL ,
	[label_id] [char] (26) NULL ,
	[date_created] [datetime] NULL ,
	[date_modified] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [LAFCMS_journal] (
	[journal_entry_id] [char] (26) NOT NULL ,
	[process_id] [char] (26) NULL ,
	[type] [int] NULL ,
	[target_id] [char] (26) NULL ,
	[date_journaled] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [LAFCMS_location] (
	[location_id] [char] (26) NOT NULL ,
	[shape] [text] NULL ,
	[date_created] [datetime] NULL ,
	[date_modified] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [LAFCMS_membership] (
	[membership_id] [char] (26) NOT NULL ,
	[container_id] [char] (26) NULL ,
	[item_id] [char] (26) NULL ,
	[location_id] [char] (26) NULL ,
	[label_id] [char] (26) NULL ,
	[date_created] [datetime] NULL ,
	[date_modified] [datetime] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [LAFCMS_association] WITH NOCHECK ADD 
	CONSTRAINT [PK_LAFCMS_association] PRIMARY KEY  CLUSTERED 
	(
		[association_id]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

ALTER TABLE [LAFCMS_journal] WITH NOCHECK ADD 
	CONSTRAINT [PK_LAFCMS_journal] PRIMARY KEY  CLUSTERED 
	(
		[journal_entry_id]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

ALTER TABLE [LAFCMS_location] WITH NOCHECK ADD 
	CONSTRAINT [PK_LAFCMS_location] PRIMARY KEY  CLUSTERED 
	(
		[location_id]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

ALTER TABLE [LAFCMS_membership] WITH NOCHECK ADD 
	CONSTRAINT [PK_LAFCMS_membership] PRIMARY KEY  CLUSTERED 
	(
		[membership_id]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

 CREATE  INDEX [ab] ON [LAFCMS_association]([associated_id_a], [associated_id_b]) ON [PRIMARY]
GO

 CREATE  INDEX [container_id] ON [LAFCMS_membership]([container_id]) ON [PRIMARY]
GO

 CREATE  INDEX [item_id] ON [LAFCMS_membership]([item_id]) ON [PRIMARY]
GO

 CREATE  INDEX [location_id] ON [LAFCMS_membership]([location_id]) ON [PRIMARY]
GO