Droplet.Entitys ���ݿ�ʵ�����
����Ŀ��ˮ�β�ѯϵͳ�����ݿ�ʵ��㣬���� .NET 8 �� Entity Framework Core����Ҫ����ϵͳ��ҵ��ģ������ݱ��ṹ��ͨ��ʵ���� + EFCore ע�⣩���� NuGet �����ṩ����������ʹ�á�
ʹ�÷�ʽ
- ��Ӧ�õ�
DbContext ������ DropletDbContext �����е�ʵ�帴�Ƶ����������ġ�
- ͨ�� EFCore Code First Ǩ���������ݿ⣺
- ����Ǩ�ƣ�
dotnet ef migrations add Init
- �������ݿ⣺
dotnet ef database update
- ���� NuGet ���ɷ�������ʵ��
DbSet<>��
ȫ�ֻ����ֶΣ��̳��� BaseEntity��
| �ֶ� |
���� |
˵�� |
| Id |
bigint Identity |
����ID |
| Remark |
nvarchar(200) |
��ע |
| Sort |
int |
����ֵ |
| DeleteYn |
bit |
�Ƿ�ɾ�� 0=δɾ�� 1=��ɾ�� |
| CreateBy |
bigint |
������ID |
| CreateByName |
nvarchar(50) |
���������� |
| CreateTime |
datetime |
����ʱ�� |
| UpdateBy |
bigint |
������ID |
| UpdateByName |
varchar(100) |
���������� |
| UpdateTime |
datetime |
����ʱ�� |
| Version |
rowversion |
�����汾�� |
˵����ArticleContentEntity δ�̳� BaseEntity��������ֻ������������ֶΡ�
ҵ�����ݱ�һ��
��̨����
D_Admin_User (AdminUserEntity)
| �ֶ� |
���� |
˵�� |
| UserName |
nvarchar(20) |
�û����� |
| UserPhone |
nvarchar(11) |
�û��ֻ��������� |
| Password |
nvarchar(50) |
�û����루���ģ� |
| EcSalt |
nvarchar(4) |
������չ��ֵ |
| UserPicture |
nvarchar(800) |
�û�ͷ�� |
| LoginCount |
int |
��¼���� |
| LastIp |
nvarchar(20) |
����¼IP |
| LastLoginDate |
datetime |
����¼ʱ�� |
D_Admin_Role (AdminRoleEntity)
| �ֶ� |
���� |
˵�� |
| RoleName |
nvarchar(20) |
��ɫ���� |
| �ֶ� |
���� |
˵�� |
| Pid |
bigint |
����ID |
| MenuName |
nvarchar(20) |
�˵����� |
| MenuVal |
nvarchar(20) |
�˵�ģ��ֵ |
| �ֶ� |
���� |
˵�� |
| AdminRoleId |
bigint |
��ɫID |
| AdminMenuId |
bigint |
�˵�ID |
D_Admin_User_Role (AdminUserRoleEntity)
| �ֶ� |
���� |
˵�� |
| AdminUserId |
bigint |
�����û�ID |
| AdminRoleId |
bigint |
������ɫID |
�û��빫˾
D_User (UserEntity)
| �ֶ� |
���� |
˵�� |
| LoginId |
nvarchar(50) |
��¼����Ψһ������ |
| UserName |
nvarchar(50) |
�û��� |
| NickName |
nvarchar(50) |
�û��dz� |
| RealName |
nvarchar(50) |
��ʵ���� |
| Mobile |
nvarchar(11) |
�ֻ��ţ�Ψһ������ |
| Password |
nvarchar(100) |
��¼���� |
| PasswordResetRequired |
tinyint |
�Ƿ����������� 0=�� 1=�� |
| Email |
nvarchar(50) |
���� |
| Gender |
tinyint |
�Ա� 0=δ֪ 1=�� 2=Ů |
| AvatarUrl |
nvarchar(800) |
ͷ���ַ |
| TryCount |
tinyint |
���������� |
| IsEnable |
tinyint |
�Ƿ� 0=δ���� 1=���� |
| LastLoginTime |
datetime |
����¼ʱ�� |
| IsForbidTrade |
tinyint |
�Ƿ��ֹ���� 0=�� 1=�� |
| IP |
nvarchar(20) |
��¼IP |
D_User_Company (UserCompanyEntity)
| �ֶ� |
���� |
˵�� |
| UserId |
bigint |
�û�ID |
| CompanyId |
bigint |
��˾ID |
D_Company (CompanyEntity)
| �ֶ� |
���� |
˵�� |
| CompanyName |
nvarchar(1000) |
��˾���� |
| CompanyNo |
nvarchar(100) |
��ҵ�� |
| CreditCode |
nvarchar(50) |
ͳһ������ô��루Ψһ������ |
| StartDate |
nvarchar(20) |
�������� |
| OperName |
nvarchar(1000) |
�������������� |
| StatusName |
nvarchar(100) |
��ҵ״̬ |
| Address |
nvarchar(1000) |
ע���ַ |
����������
D_Article_Category (ArticleCategoryEntity)
| �ֶ� |
���� |
˵�� |
| ParentId |
bigint |
����ID |
| CategoryName |
nvarchar(20) |
�������� |
| CategoryCode |
nvarchar(20) |
������ |
D_Article (ArticleEntity)
| �ֶ� |
���� |
˵�� |
| ArticleCategoryId |
bigint |
����ID�������� |
| ArticleTitle |
nvarchar(500) |
���� |
| ArticleAuthor |
nvarchar(50) |
���� |
| MainImage |
nvarchar(800) |
��ͼ |
| ReleaseTime |
datetime |
����ʱ�� |
| ContentSummary |
nvarchar(500) |
��� |
| Status |
tinyint |
״̬ 1=�ϼ� 0=�¼� |
D_Article_Content (ArticleContentEntity)
| �ֶ� |
���� |
˵�� |
| Id |
bigint Identity |
����ID |
| ArticleId |
bigint |
����ID��Ψһ������ |
| ArticleContent |
text |
�������� |
| Keywords |
nvarchar(255) |
�ؼ��֣������� |
��ҳ����
D_Home_Banner (HomeBannerEntity)
| �ֶ� |
���� |
˵�� |
| BannerImageUrl |
nvarchar(600) |
��ͼ��ַ |
| LinkUrl |
nvarchar(600) |
��ת���� |
| BannerType |
tinyint |
�ֲ�ͼ���� 1=��ҳ |
D_Home_Product (HomeProductEntity)
| �ֶ� |
���� |
˵�� |
| ProductId |
bigint |
��ƷID |
��Ʒ��SKU
D_Product_Category (ProductCategoryEntity)
| �ֶ� |
���� |
˵�� |
| ParentId |
bigint |
����ID |
| CategoryName |
nvarchar(50) |
�������� |
| CategoryCode |
nvarchar(50) |
������� |
D_Product (ProductEntity)
| �ֶ� |
���� |
˵�� |
| StoreId |
bigint |
����ID�������� |
| ProductCategoryId |
bigint |
��Ʒ����ID�������� |
| ProductName |
nvarchar(200) |
��Ʒ���� |
| ProductPrice |
decimal(12,2) |
��Ʒ�۸� |
| ProductNum |
int |
��Ʒ��� |
| ProductType |
tinyint |
���� 1=���� 2=��һ�ײ� 3=�ۺ��ײ� |
| ReleaseYn |
tinyint |
�Ƿ��ϼ� 0=�� 1=�� |
| ProductMainImage |
nvarchar(800) |
��Ʒ��ͼ |
| ProductSummary |
nvarchar(500) |
��Ʒ��� |
| UseStartTime |
datetime |
ʹ�����ڿ�ʼʱ�� |
| UseEndTime |
datetime |
ʹ�����ڽ���ʱ�� |
D_Product_Sku (ProductSkuEntity)
| �ֶ� |
���� |
˵�� |
| ProductId |
bigint |
��ƷID�������� |
| StoreId |
bigint |
����ID�������� |
| ProductCategoryId |
bigint |
��Ʒ����ID�������� |
| SkuName |
nvarchar(200) |
SKU���� |
| SkuPrice |
decimal(12,2) |
SKU�۸� |
| SkuNum |
int |
SKU��� |
| SkuType |
tinyint |
���� 1=���� 2=��һ�ײ� 3=�ۺ��ײ� |
| SkuMainImage |
nvarchar(200) |
SKU��ͼ |
| SkuSummary |
nvarchar(500) |
SKU��� |
| SkuUseStartTime |
datetime |
ʹ�����ڿ�ʼ |
| SkuUseEndTime |
datetime |
ʹ�����ڽ��� |
�����뽻��
D_Order (OrderEntity)
| �ֶ� |
���� |
˵�� |
| StoreId |
bigint |
����ID�������� |
| UserId |
bigint |
�û�ID�������� |
| CompanyId |
bigint |
��˾ID�������� |
| OrderNo |
nvarchar(20) |
�����ţ�Ψһ������ |
| OrderAmount |
decimal(12,2) |
������� |
| OrderType |
tinyint |
�������� 1=��ͨ���� 2=���ܹ��� |
| Status |
tinyint |
״̬ 0=��ȷ�� 1=��֧�� 2=�����ɱ��� 3=����� 4=��ȡ�� 5=�ѹر� |
| PayStatus |
tinyint |
֧��״̬ 0=δ֧�� 1=��֧�� 2=�˿��� 3=���˿� 4=�˿�ʧ�� |
| PayAmount |
decimal(12,2) |
֧����� |
| PayTime |
datetime |
֧��ʱ�� |
D_Order_Item (OrderItemEntity)
| �ֶ� |
���� |
˵�� |
| StoreId |
bigint |
����ID |
| UserId |
bigint |
�û�ID |
| CompanyId |
bigint |
��˾ID |
| OrderNo |
nvarchar(20) |
������ |
| OrderNum |
int |
�������� |
| OrderType |
tinyint |
�������� 1=ֱ�ӹ��� 2=���ܹ��� |
| ProductId |
bigint |
��ƷID |
| ProductName |
nvarchar(200) |
��Ʒ���� |
| ProductType |
tinyint |
��Ʒ���� 1=���� 2=��һ�ײ� 3=�ۺ��ײ� |
| ProductMainImage |
nvarchar(800) |
��Ʒ��ͼ |
| ProductCategoryId |
bigint |
��Ʒ����ID |
| ProductSkuName |
nvarchar(200) |
SKU���� |
| ProductSkuPrice |
decimal(12,2) |
SKU�۸� |
| ProductSkuType |
tinyint |
SKU���� |
| ProductSkuMainImage |
nvarchar(800) |
SKU��ͼ |
| ProductSkuSummary |
nvarchar(200) |
SKU��� |
| ProductSkuUseStartTime |
datetime |
SKUʹ�ÿ�ʼʱ�� |
| ProductSkuUseEndTime |
datetime |
SKUʹ�ý���ʱ�� |
D_Order_Key (OrderKeyEntity)
| �ֶ� |
���� |
˵�� |
| StoreId |
bigint |
����ID |
| UserId |
bigint |
�û�ID |
| CompanyId |
bigint |
��˾ID |
| OrderItemId |
bigint |
������ϸID |
| OrderNo |
nvarchar(20) |
������ |
| CodeId |
bigint |
��¼ID��Ψһ������ |
| Code |
nvarchar(50) |
����ֵ |
| CodeState |
tinyint |
����״̬ 1=��ʹ�� 2=��ʹ�� |
| CodeOId |
bigint |
�һ���¼ID��Ψһ������ |
| CodeAddTime |
datetime |
����ʱ�� |
| CodeDhTime |
datetime |
�һ�ʱ�� |
| CodeOrderNo |
nvarchar(50) |
��� |
D_Order_Report (OrderReportEntity)
| �ֶ� |
���� |
˵�� |
| StoreId |
bigint |
����ID |
| UserId |
bigint |
�û�ID |
| CompanyId |
bigint |
��˾ID |
| OrderItemId |
bigint |
������ϸID |
| OrderNo |
nvarchar(20) |
������ |
| BackStr |
nvarchar(50) |
��¼��ˮ�ţ�Ψһ������ |
| Rid |
bigint |
����ID��Ψһ������ |
| File |
nvarchar(50) |
�����ļ���ַ |
| Name |
nvarchar(50) |
��˾���� |
| Code |
nvarchar(50) |
���ͳһ���루Ψһ������ |
| State |
tinyint |
״̬ 3=��ʹ�� 4=����֤ |
| AddTime |
datetime |
����ʱ�� |
| DomicileDistrict |
nvarchar(50) |
������� |
| Hydm |
nvarchar(50) |
��ҵ���� |
| Report |
nvarchar(50) |
�������� |
| Url |
nvarchar(50) |
��Ȩ��ַ |
֧��
D_Payment_Channel (PaymentChannelEntity)
| �ֶ� |
���� |
˵�� |
| Name |
nvarchar(50) |
֧���������� |
| Code |
nvarchar(50) |
֧��������ʶ��Ψһ������ |
| FundAccountType |
tinyint |
�ʽ��˻����� 1=��� 2=������� 3=����B2B 4=����B2B |
| IsActive |
bit |
�Ƿ� |
| SettlementStartTime |
nvarchar(10) |
���㿪ʼʱ�� |
| SettlementEndTime |
nvarchar(10) |
�������ʱ�� |
| LogoUrl |
nvarchar(800) |
ͨ��logo |
| IsDirect |
bit |
�Ƿ�ֱ��֧�� |
| IsQRCode |
bit |
�Ƿ��ά��֧�� |
| PayOrderNoPrefix |
nvarchar(10) |
֧��������ǰ |
| OpenType |
tinyint |
�Ƿ�ʱ��ο��� 1=�� 2=�� |
| OpenHoursStart |
tinyint |
��ʱ�ο�ʼСʱ |
| OpenHoursEnd |
tinyint |
��ʱ�ν���Сʱ |
| OpenHoursType |
bit |
�Ƿ���� 0=�� 1=�� |
| PayBlurb |
nvarchar(50) |
֧����� |
| PayIcon |
nvarchar(20) |
֧��icon class �� |
| InstallmentNumbers |
nvarchar(50) |
�������ã����ŷָ��� |
| ShowYn |
bit |
�Ƿ���ʾ |
| TerminalId |
nvarchar(50) |
�ն˺� |
| IsSplitFee |
bit |
�������Ƿ��̯ |
| IsUseRate |
bit |
�Ƿ��÷��ʼ��� |
| IsPrepaid |
bit |
�Ƿ�Ԥ���� |
| Fee |
decimal(12,2) |
�������� |
| SettlementCycle |
nvarchar(40) |
�������� |
D_Payment_Channel_Config (PaymentChannelConfigEntity)
| �ֶ� |
���� |
˵�� |
| PaymentChannelId |
bigint |
֧��ͨ��ID�������� |
| PlatformType |
tinyint |
ƽ̨ 1=PC 2=�� 3=H5 4=App |
����
D_Store (StoreEntity)
| �ֶ� |
���� |
˵�� |
| StoreName |
nvarchar(50) |
�������� |
������Լ��ժҪ
- Ψһ������
OrderEntity.OrderNo��PaymentChannelEntity.Code��UserEntity.LoginId��UserEntity.Mobile��CompanyEntity.CreditCode��OrderReportEntity.BackStr��OrderReportEntity.Rid��OrderReportEntity.Code��OrderKeyEntity.CodeId��OrderKeyEntity.CodeOId��ArticleContentEntity.ArticleId
- ������������ʵ��Գ��ò�ѯ�ֶ���Ͻ�����ͨ�����������������ܡ�
�汾����
NuGet ��ͨ����Ŀ�ļ����� GeneratePackageOnBuild=True �Զ����ɣ����·����Release Ŀ¼��
������� .csproj �����ӣ�
<None Include="README.md" Pack="True" PackagePath="/" />
���ں��������������Ա������˵���ļ���
��Ȩ
Copyright ? jtx.top