【net毕业设计】健身房管理系统源码（完整前后端+sqlserver+说明文档+LW）.zip

/* Navicat SQL Server Data Transfer Source Server : 127.0.0.1-sqlserver Source Server Version : 105000 Source Host : 127.0.0.1:1433 Source Database : net6yx95 Source Schema : dbo Target Server Type : SQL Server Target Server Version : 105000 File Encoding : 65001 Date: 2020-12-15 14:01:38 */ -- ---------------------------- -- Table structure for address -- ---------------------------- DROP TABLE [dbo].[address] GO CREATE TABLE [dbo].[address] ( [id] bigint NOT NULL , [userid] bigint NOT NULL , [address] varchar(200) NOT NULL , [name] varchar(200) NOT NULL , [phone] varchar(200) NOT NULL , [isdefault] varchar(200) NOT NULL , [addtime] datetime NOT NULL DEFAULT (getdate()) ) GO IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'address', 'COLUMN', N'id')) > 0) EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'主键' , @level0type = 'SCHEMA', @level0name = N'dbo' , @level1type = 'TABLE', @level1name = N'address' , @level2type = 'COLUMN', @level2name = N'id' ELSE EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'主键' , @level0type = 'SCHEMA', @level0name = N'dbo' , @level1type = 'TABLE', @level1name = N'address' , @level2type = 'COLUMN', @level2name = N'id' GO IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'address', 'COLUMN', N'userid')) > 0) EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'用户id' , @level0type = 'SCHEMA', @level0name = N'dbo' , @level1type = 'TABLE', @level1name = N'address' , @level2type = 'COLUMN', @level2name = N'userid' ELSE EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'用户id' , @level0type = 'SCHEMA', @level0name = N'dbo' , @level1type = 'TABLE', @level1name = N'address' , @level2type = 'COLUMN', @level2name = N'userid' GO IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'address', 'COLUMN', N'address')) > 0) EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'地址' , @level0type = 'SCHEMA', @level0name = N'dbo' , @level1type = 'TABLE', @level1name = N'address' , @level2type = 'COLUMN', @level2name = N'address' ELSE EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'地址' , @level0type = 'SCHEMA', @level0name = N'dbo' , @level1type = 'TABLE', @level1name = N'address' , @level2type = 'COLUMN', @level2name = N'address' GO IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'address', 'COLUMN', N'name')) > 0) EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'收货人' , @level0type = 'SCHEMA', @level0name = N'dbo' , @level1type = 'TABLE', @level1name = N'address' , @level2type = 'COLUMN', @level2name = N'name' ELSE EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'收货人' , @level0type = 'SCHEMA', @level0name = N'dbo' , @level1type = 'TABLE', @level1name = N'address' , @level2type = 'COLUMN', @level2name = N'name' GO IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'address', 'COLUMN', N'phone')) > 0) EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'电话' , @level0type = 'SCHEMA', @level0name = N'dbo' , @level1type = 'TABLE', @level1name = N'address' , @level2type = 'COLUMN', @level2name = N'phone' ELSE EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'电话' , @level0type = 'SCHEMA', @level0name = N'dbo' , @level1type = 'TABLE', @level1name = N'address' , @level2type = 'COLUMN', @level2name = N'phone' GO IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'address', 'COLUMN', N'isdefault')) > 0) EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'是否默认地址[是/否]' , @level0type = 'SCHEMA', @l�