部分常见银行的名称和图标对应表

最新推荐文章于 2024-01-25 00:59:50 发布

月牙天羽

最新推荐文章于 2024-01-25 00:59:50 发布

阅读量1.9k

点赞数

CC 4.0 BY-SA版权

分类专栏：日常总结文章标签： sql

本文链接：https://blog.youkuaiyun.com/NARUTONEPIECE/article/details/108974509

日常总结专栏收录该内容

20 篇文章

订阅专栏

本文档详细介绍了HMEShop系统中银行信息表(Hmeshop_BankInfo)的数据库表结构及其初始化数据。该表记录了不同银行的名称、标志图标及背景图片等信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

/****** Object: Table [dbo].[Hmeshop_BankInfo] Script Date: 2020/10/9 10:41:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Hmeshop_BankInfo](
[Id] [int] IDENTITY(1,1) NOT NULL,
[BankName] varchar NULL,
[Logo] varchar NULL,
[BackgroundImg] varchar NULL,
CONSTRAINT [PK_Hmeshop_BankInfo] PRIMARY KEY CLUSTERED
(
[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]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Hmeshop_BankInfo] ON

INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (1, N’其它银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_0_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_0.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (2, N’中国建设银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_01_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_01.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (3, N’中国工商银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_02_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_02.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (4, N’中国农业银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_03_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_03.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (5, N’中国银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_04_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_04.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (6, N’交通银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_05_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_05.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (7, N’中国邮政’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_06_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_06.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (8, N’招商银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_07_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_07.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (9, N’中国民生银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_08_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_08.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (10, N’上海浦东发展银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_09_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_09.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (11, N’广发银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_10_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_10.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (12, N’中信银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_11_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_11.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (13, N’中国光大银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_12_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_12.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (14, N’兴业银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_13_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_13.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (15, N’华夏银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_14_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_14.png’)
INSERT [dbo].[Hmeshop_BankInfo] ([Id], [BankName], [Logo], [BackgroundImg]) VALUES (16, N’中国平安银行’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_15_1.png’, N’http://img.hmeshop.cn/RLS/BankLogo/BankImage/bank_15.png’)
SET IDENTITY_INSERT [dbo].[Hmeshop_BankInfo] OFF
EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’标志图标’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Hmeshop_BankInfo’, @level2type=N’COLUMN’,@level2name=N’Logo’
GO
EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’背景图片’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Hmeshop_BankInfo’, @level2type=N’COLUMN’,@level2name=N’BackgroundImg’
GO