Home Explore Help
Register Sign In
LYFZ
/
lyfz_repos
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
lyfz_repos
/
经典版源码
/
document
/
数据库新版本脚本
/
未成型脚本
/
lyfzEmployeeInfo.sql

lyfzEmployeeInfo.sql 1.8 KB
Permalink History Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455 
  1. USE [lyfz]
    2. 

  2. GO
    3. 

  3. /****** 表中文名：lyfz员工信息 ******/
    4. 

  4. /****** 对象:  Table [dbo].[lyfzEmployeeInfo]    脚本日期: 08/20/2014 20:06:02 ******/
    5. 

  5. SET ANSI_NULLS ON
    6. 

  6. GO
    7. 

  7. SET QUOTED_IDENTIFIER ON
    8. 

  8. GO
    9. 

  9. SET ANSI_PADDING ON
    10. 

  10. GO
    11. 

  11. CREATE TABLE [dbo].[lyfzEmployeeInfo](					
    12. 

  12. 	[employee_id] [varchar](50) NOT NULL,					/* 员工id(id编号方式:另定) */
    13. 

  13. 	[employee_name] [varchar](50) NULL,						/* 员工姓名 */
    14. 

  14. 	[employee_sex] [varchar](50) NULL,						/* 员工性别 */
    15. 

  15. 	[employee_identityCard]	[varchar](50) NULL,				/* 员工身份证 */
    16. 

  16. 	[employee_nativePlace][varchar](50)NULL,				/* 员工籍贯 */
    17. 

  17. 	[employee_dept][varchar](50)NULL,						/* 员工部门 */
    18. 

  18. 	/* 部门职位 */
    19. 

  19. 	[employee_phone][varchar](50)NULL,						/* 员工电话*/
    20. 

  20. 	[employee_QQ][varchar](50)NULL,							/* 员工QQ */
    21. 

  21. 	[employee_maritalStatus][varchar](50)NULL,				/* 员工婚否 */
    22. 

  22. 	[employee_currentAddress][varchar](50)NULL,				/* 员工现居地址 */
    23. 

  23. 	[employee_incumbency][varchar](50)NULL,					/* 在职否 */
    24. 

  24. 	[employee_entryTime][varchar](50)NULL,					/* 入职时间 */
    25. 

  25. 	[employee_][varchar](50)NULL,
    26. 

  26. 	[employee_][varchar](50)NULL,
    27. 

  27. 	[employee_][varchar](50)NULL,
    28. 

  28. 	[employee_][varchar](50)NULL,
    29. 

  29. 	[employee_][varchar](50)NULL,
    30. 

  30. 	[employee_][varchar](50)NULL,
    31. 

  31. 	[employee_][varchar](50)NULL,
    32. 

  32. 	[employee_][varchar](50)NULL,
    33. 

  33. 	[employee_][varchar](50)NULL,
    34. 

  34. 	[employee_][varchar](50)NULL,
    35. 

  35. 	[employee_][varchar](50)NULL,
    36. 

  36. 	[employee_][varchar](50)NULL,
    37. 

  37. 	[employee_][varchar](50)NULL,
    38. 

  38. 	[employee_][varchar](50)NULL,
    39. 

  39. 	[employee_][varchar](50)NULL,
    40. 

  40. 	[employee_][varchar](50)NULL,
    41. 

  41. 	[employee_][varchar](50)NULL,
    42. 

  42. 	[employee_][varchar](50)NULL,
    43. 

  43. 	[employee_][varchar](50)NULL,
    44. 

  44. 	[employee_][varchar](50)NULL,
    45. 

  45. 	[employee_][varchar](50)NULL,
    46. 

  46. 	[employee_][varchar](50)NULL,
    47. 

  47. 	[employee_][varchar](50)NULL,
    48. 

  48. 	[employee_][varchar](50)NULL,
    49. 

  49. 	[employee_][varchar](50)NULL,
    50. 

  50. 	[employee_remarks] [varchar](50) NULL,					/* 备注 */
    51. 

  51. 

  52. ) ON [PRIMARY]
    53. 

  53. 

  54. GO
    55. 

  55. SET ANSI_PADDING OFF
    56.