喜鹊软件旗下官网: C/S框架网 | 表网
当前位置: 首页 > 表结构
关于作者
MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)|YX_SYCS|YX_SYCS- 表网 - 网罗天下表结构

表名:YX_SYCS - YX_SYCS

2021/4/13 15:34:00 admin
表网,软件开发系统需求分析设计文档-YX_SYCS-YX_SYCS-MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)
项目编号:
 MIS210413152328685
项目名称:
MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)
系统名称:
MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)(MIS系统)
数据库类型:
MSSQL
表名:
YX_SYCS
简称:
YX_SYCS
描述:
MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版) - YX_SYCS
# 名称 标题 类型 长度 小数 允许空 自增 主键 外键 索引 描述
1 Area_id 营业区标识 int 4 0 Y Area_id,区域id
2 area_name 地区名称 varchar 20 0 Y area_name,区域名称
3 House_Addressinfo House_Addressinfo varchar 100 0 Y House_Addressinfo
4 House_Addrinfo House_Addrinfo varchar 100 0 Y House_Addrinfo
5 House_BianHao House_BianHao varchar 50 0 Y House_BianHao
6 House_BuildYear House_BuildYear int 4 0 Y House_BuildYear
7 House_Buslineinfo House_Buslineinfo varchar 100 0 Y House_Buslineinfo
8 House_CellCount House_CellCount int 4 0 Y House_CellCount
9 House_CertID House_CertID varchar 50 0 Y House_CertID
10 House_Chamber House_Chamber varchar 50 0 Y House_Chamber
11 House_CityName House_CityName varchar 10 0 Y House_CityName
12 House_CloseArea House_CloseArea varchar 50 0 Y House_CloseArea
13 House_CommentNum House_CommentNum int 4 0 Y House_CommentNum
14 House_Condition House_Condition varchar 10 0 Y House_Condition
15 House_ConsignID House_ConsignID varchar 50 0 Y House_ConsignID
16 House_CountexPress House_CountexPress varchar 50 0 Y House_CountexPress
17 House_ExternalWall House_ExternalWall varchar 10 0 Y House_ExternalWall
18 House_Feature House_Feature varchar 1000 0 Y House_Feature
19 House_Floor House_Floor int 4 0 Y House_Floor
20 House_Forward House_Forward varchar 50 0 Y House_Forward
21 House_Garden House_Garden varchar 100 0 Y House_Garden
22 House_Hit House_Hit int 4 0 Y House_Hit
23 House_ID House_ID int 4 0 House_ID,房屋ID
24 House_IsCheck House_IsCheck bit 1 0 Y House_IsCheck
25 House_Type House_Type varchar 50 0 Y House_Type
26 House_Size1 House_Size1 float 8 0 Y House_Size1
27 House_Size2 House_Size2 float 8 0 Y House_Size2
28 House_Size3 House_Size3 float 8 0 Y House_Size3
29 House_HouseType House_HouseType varchar 9 0 Y House_HouseType
30 House_InputPrice House_InputPrice decimal 9 2 Y House_InputPrice
31 House_RepaiDegree House_RepaiDegree varchar 50 0 Y House_RepaiDegree
32 House_RoomNum House_RoomNum int 4 0 Y House_RoomNum
33 House_OfficeNum House_OfficeNum int 4 0 Y House_OfficeNum
34 House_WashNum House_WashNum int 4 0 Y House_WashNum
35 House_Use House_Use varchar 50 0 Y House_Use
36 House_TotalFloor House_TotalFloor int 4 0 Y House_TotalFloor
37 House_Right House_Right varchar 20 0 Y House_Right
38 House_RoomSetting House_RoomSetting varchar 100 0 Y House_RoomSetting
39 House_RoomFixing House_RoomFixing varchar 100 0 Y House_RoomFixing
40 House_PouseOwnerMemo House_PouseOwnerMemo varchar 1000 0 Y House_PouseOwnerMemo
41 House_Structure House_Structure varchar 10 0 Y House_Structure
42 House_StopCar House_StopCar varchar 50 0 Y House_StopCar
43 House_ServicePrice House_ServicePrice float 8 0 Y House_ServicePrice
44 House_ServiceexPress House_ServiceexPress varchar 50 0 Y House_ServiceexPress
45 House_School House_School varchar 100 0 Y House_School
46 House_Piazza House_Piazza varchar 100 0 Y House_Piazza
47 House_Street House_Street varchar 100 0 Y House_Street
48 House_Special House_Special varchar 200 0 Y House_Special
49 House_ReleaseDay House_ReleaseDay int 4 0 Y House_ReleaseDay
50 House_OwnerName House_OwnerName varchar 50 0 Y House_OwnerName
51 House_Ownersex House_Ownersex varchar 50 0 Y House_Ownersex
52 House_OwnerPhone1 House_OwnerPhone1 varchar 20 0 Y House_OwnerPhone1
53 House_OwnerPhone2 House_OwnerPhone2 varchar 20 0 Y House_OwnerPhone2
54 House_OwnerIDCard House_OwnerIDCard varchar 18 0 Y House_OwnerIDCard
55 House_OwnerEmail House_OwnerEmail varchar 50 0 Y House_OwnerEmail
56 House_IsCommend House_IsCommend bit 1 0 Y House_IsCommend
57 House_PinYin House_PinYin varchar 50 0 Y House_PinYin
58 House_ShortPinYin House_ShortPinYin varchar 20 0 Y House_ShortPinYin
59 House_PublishDate House_PublishDate datetime 8 3 Y House_PublishDate
60 House_IsHavePicture House_IsHavePicture bit 1 0 Y House_IsHavePicture
61 House_LeaveDay House_LeaveDay int 4 0 Y House_LeaveDay
62 House_State House_State varchar 50 0 Y House_State
63 House_PublishIP House_PublishIP varchar 50 0 Y House_PublishIP
64 House_LastModifyTime House_LastModifyTime datetime 8 3 Y House_LastModifyTime
65 House_ModifyNum House_ModifyNum int 4 0 Y House_ModifyNum
66 House_Items House_Items int 4 0 Y House_Items
67 U_ID 用户编号 int 4 0 Y U_ID,身份证号码
68 U_Name U_Name varchar 50 0 Y U_Name
69 House_YangTaiNum House_YangTaiNum int 4 0 Y House_YangTaiNum
70 House_YiLiao House_YiLiao varchar 100 0 Y House_YiLiao
71 House_YuYueNum House_YuYueNum int 4 0 Y House_YuYueNum
72 tp_name tp_name varchar 100 0 Y tp_name,tp_名称
VIP用户下载:
下载表结构XLS文件 - MSSQL格式(默认)
下载表结构SQL脚本 - MsSQL格式
下载表结构SQL脚本 - MySQL格式
下载表结构SQL脚本 - Oracle格式
项目名称:
MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)
项目简介:
所谓MIS(管理信息系统--Management Information System)系统,主要指的是进行日常事务操作的系统。这种系统主要用于管理需要的记录,并对记录数据进行相关处理,将处理的信息及时反映给管理者的一套网络管理系统。MIS(管理信息系统--Management Information System)系统 ,是一个由人、计算机及其他外围设备等组成的能进行信息的收集、传递、存贮、加工、维护和使用的系统。 易想房产网YxHouse 2.1 (金色大气版) 易想房产网YxHouse 2.1 (金色大气版) 易想房产网YxHouse 2.1 (金色大气版)
相关表结构:
MSSQL-MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)【表名:aspnet_Applications】aspnet应用程序
MSSQL-MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)【表名:aspnet_WebEvent_Events】aspnet_ WebEvent_事件
MSSQL-MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)【表名:aspnet_UsersInRoles】aspnet_用户角色
MSSQL-MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)【表名:aspnet_Users】aspnet_用户
MSSQL-MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)【表名:aspnet_SchemaVersions】原文:aspnet_SchemaVersions
MSSQL-MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)【表名:aspnet_Roles】aspnet_角色
MSSQL-MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)【表名:aspnet_Profile】aspnet_配置文件
MSSQL-MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)【表名:aspnet_PersonalizationPerUser】aspnet_个性化浏览器
MSSQL-MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)【表名:aspnet_PersonalizationAllUsers】aspnet_个性化LUSERS
MSSQL-MIS-管理信息系统-易想房产网YxHouse 2.1 (金色大气版)【表名:YX_SYCS】YX_SYCS