| AutoID | int | | false | | |
| AppID | varchar(64) | PK | false | | App ID |
| AppName | varchar(256) | | true | | App name |
| Avatar | varchar(128) | | true | | Avatar |
| Summary | varchar(256) | | true | | Profile |
| About | varchar(1024) | | true | | Description |
| IS_Personal | bit | | true | | Personal application or not |
| IS_Free | bit | | true | | Free or not |
| IS_Private | bit | | true | 0 | Private or not |
| ProjectIDRange | varchar(1024) | | true | | ID of the installed network |
| ShowModel | tinyint | | false | 0 | Display mode. (0: standalone page, 1:I-form, 2:T-form) |
| Pricing_Fee | decimal | | true | 0 | Billing |
| Pricing_Unit | tinyint | | true | 0 | Billing unit |
| Pricing_Time | tinyint | | true | 0 | Time unit of billing |
| Pricing_Type | tinyint | | true | 3 | Billing type. LOV: 1 for prepayment, 2 for postpayment, 3 a combination of these two |
| Pricing_Mark | varchar(1024) | | true | | Billing description |
| NoticeUrl | varchar(256) | | true | | Notification of successful payment |
| AppUrl | varchar(128) | | true | | External access address of the application |
| HomeUrl | varchar(128) | | true | | Internal home page of the application |
| SettingUrl | varchar(128) | | true | | Application's setting address |
| Consumer_Key | varchar(128) | | true | | Application token |
| Consumer_Secret | varchar(128) | | true | | Application token key |
| Authorize_sign | tinyint | | true | 0 | Authorized login method. (0: all 1: transit authorization) |
| Authorize_lic | tinyint | | true | 0 | Authorization type. (0: basic authorization 1: advanced authorization) |
| Calback_Url | varchar(128) | | true | | Callback address |
| Rating | decimal | | true | | Application rating |
| Num_User | int | | true | | Number of users who installed the app |
| Num_Post | int | | true | | Number of comments posted |
| ProjectID | varchar(64) | | true | | Network ID |
| CreateUser | varchar(64) | | true | | Creator Account ID |
| LastModifyUser | varchar(64) | | true | | Modifier Account ID |
| Status | smallint | | true | | Status. (-2:All, -1:Deleted, 1: Not published, 2:Published, 4:Reviewing, 5:Reviewing failed, 6:Debugging, 7: Withdrawn and reviewing, 8: Withdrawing and reviewing failed, 9:Present only, 10: Withdraw) |
| Type | tinyint | | true | | Application type. (-1: All, 0: Common, 1: Basic, 2: Desktop, 3: Mobile, 4: Web, 5: Mobile and Web) |
| ReMark | varchar(512) | | true | | Notes |
| CategoryID | varchar(64) | | true | | Category ID |
| GeoID | int | | false | 1 | Region ID |
| DeviceField | varchar(512) | | true | | For IOS: ios_appid; for ANDROID: android_downurl|android_package (package name of Android application)|android_activity (startup activity of Android application) |
| CreateTime | datetime | | true | | Date created |
| UpdateTime | datetime | | true | | Date updated |
| PublicTime | datetime | | true | | Date published |
| ApplyStatus | smallint | | true | | Status. (-2:All, -1:Deleted, 1: Not published, 2:Published, 4:Reviewing, 5:Reviewing failed, 6:Debugging, 7: Withdrawn and reviewing, 8: Withdrawing and reviewing failed, 9:Present only, 10: Withdraw) |
| Is_Wap | bit | | true | 1 | Wap display is supported or not |
| SubscibeUrl | varchar(256) | | true | | Notification address of the app subscription |
| AppCode | varchar(1024) | | true | | QR code |
| AppmdConnect | varchar(1024) | | true | | Integration items for HAP |
| AppCompanyName | varchar(1024) | | true | | Company name |
| AppContact | varchar(1024) | | true | | Customer service method |
| URLScheme | varchar(1024) | | true | | URL Scheme |
| AndroidSSO | bit | | true | | Breakthrough to HAP accounts on Android |
| IosSSO | bit | | true | | Breakthrough to HAP accounts on iOS |
| AppEmail | varchar(1024) | | true | | Email for feedback |
| H5Url | varchar(1024) | | true | | URL for mobile adaptation |
| AccountID | varchar(64) | | true | | Account ID |
| WebHookUrl | varchar(500) | | true | | Webhook address |
| Modules | varchar(100) | | true | | Data access module. 1: Contacts, 2: Messages, 3: Post, 4: Task, 5: Calendar, 6: Knowledge, 7: Approval, 8: Attendance |
| WebHookCode | varchar(20) | | true | | |
| WebHookStatus | int | | true | 1 | Webhook status. (1: supported, 8: suspended) |