1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
CREATE TABLE [dbo].[customer] (
[customer_id] int IDENTITY(1, 1) NOT NULL,
[customer_name] nvarchar(100) NULL,
[customer_group] nvarchar(100) NULL,
[customer_city] nvarchar(100) NULL,
[customer_country] int NULL)
ON [PRIMARY]
CREATE TABLE [dbo].[customer_equipment] (
[ce_id] int IDENTITY(1, 1) NOT NULL,
[ce_client_id] int NULL,
[ce_name] nvarchar(100) NULL,
[ce_type] nvarchar(100) NULL,
[ce_emplacement] nvarchar(100) NULL,
[ce_built_year] int NULL,
[ce_description] nvarchar(100) NULL,
[ce_ladle_weight] int NULL)
ON [PRIMARY] |
Partager