| | |
|---|
| | | [modi_time] [datetime] NULL, |
|---|
| | | [appe_user] [bigint] NULL, |
|---|
| | | [appe_time] [datetime] NULL, |
|---|
| | | [state] [varchar](10) NULL, |
|---|
| | | CONSTRAINT [PK_asr_loc_normal] PRIMARY KEY CLUSTERED |
|---|
| | | ( |
|---|
| | | [matnr] ASC |
|---|
| | | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
|---|
| | | [state] [varchar](10) NULL |
|---|
| | | ) ON [PRIMARY] |
|---|
| | | |
|---|
| | | CREATE TABLE [dbo].[asr_loc_area]( |
|---|
| | | [id] [bigint] IDENTITY(1,1) NOT NULL, |
|---|
| | | [uuid] [varchar](50) NULL, |
|---|
| | | [name] [varchar](255) NULL, |
|---|
| | | [status] [int] NULL, |
|---|
| | | [create_by] [bigint] NULL, |
|---|
| | | [create_time] [datetime] NULL, |
|---|
| | | [update_by] [bigint] NULL, |
|---|
| | | [update_time] [datetime] NULL, |
|---|
| | | [memo] [varchar](255) NULL |
|---|
| | | ) ON [PRIMARY] |
|---|
| | | |
|---|
| | | /* v1.0.3 2021.03.11 */ |
|---|
| | | --表结构变更 |
|---|
| | | alter table asr_loc_normal add id int identity(1,1) |
|---|
