SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[employee]( [emp_id] [int] NOT NULL, [id_card] [varchar](18) NULL, [name] [varchar](20) NULL, [gender] [varchar](2) NULL, [birthdate] [date] NULL, [phone] [varchar](11) NULL, PRIMARY KEY CLUSTERED ( [emp_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], UNIQUE NONCLUSTERED ( [phone] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], UNIQUE NONCLUSTERED ( [id_card] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO给出上述表的数据字典

表名：employee

列名：
- emp_id：整数类型，非空，员工编号
- id_card：字符串类型，长度为18，可空，身份证号
- name：字符串类型，长度为20，可空，员工姓名
- gender：字符串类型，长度为2，可空，员工性别
- birthdate：日期类型，可空，员工出生日期
- phone：字符串类型，长度为11，可空，员工手机号码

约束：
- 主键约束：emp_id
- 唯一约束：phone、id_card