WEB_PASS_PRO Database Schema
⇧Table dbo.APP_LOG
Table ID: 1605580758; Created: August 07, 2014, 09:46:38; Modified: August 07, 2014, 09:46:38
| Name |
Type |
NULL |
Comment |
| ◆zz_row_id |
int |
☐ |
IDENTITY |
| user_id |
int |
☐ |
|
| timestamp |
datetime |
☐ |
|
| url |
varchar (255) |
☐ |
|
| page |
varchar (100) |
☐ |
|
| ip_address |
varchar (50) |
☐ |
|
| log_code |
int |
☒ |
|
| log_notes |
varchar (255) |
☒ |
|
| browser_name |
varchar (100) |
☒ |
|
| browser_version |
varchar (32) |
☒ |
|
| is_postback |
smallint |
☐ |
DEFAULT ((0)) |
⇧Table dbo.CAPTCHA_DATA
Table ID: 1701581100; Created: August 08, 2014, 09:27:32; Modified: August 08, 2014, 09:27:32
| Name |
Type |
NULL |
Comment |
| ◆zz_row_id |
int |
☐ |
IDENTITY |
| ◆type |
int |
☐ |
|
| ◆code |
varchar (20) |
☐ |
|
| file_name |
varchar (50) |
☐ |
|
⇧Table dbo.PASSWORDS
Table ID: 1362103893; Created: September 09, 2014, 13:37:28; Modified: September 09, 2014, 13:37:28
| Name |
Type |
NULL |
Comment |
| ◆zz_row_id |
int |
☐ |
IDENTITY |
| name |
nvarchar (255) |
☐ |
|
| pwd_info |
nvarchar (1024) |
☐ |
|
| pwd_type_id |
int |
☐ |
|
| pwd_cycle |
int |
☐ |
|
| pwd_force_complex |
smallint |
☐ |
|
| pwd |
nvarchar (1024) |
☐ |
|
| pwd_suggested |
nvarchar (1024) |
☐ |
|
| pwd_notes |
nvarchar (4000) |
☐ |
|
| users_id |
int |
☐ |
|
| pwd_config_id |
int |
☐ |
|
| active |
smallint |
☐ |
DEFAULT ((1)) |
| trashed |
smallint |
☐ |
DEFAULT ((0)) |
| created_on |
datetime |
☐ |
DEFAULT (getdate()) |
| trashed_on |
datetime |
☒ |
|
| deactivated_on |
datetime |
☒ |
|
⇧Table dbo.PWD_CONFIG
Table ID: 1234103437; Created: September 05, 2014, 14:16:40; Modified: September 05, 2014, 14:16:40
| Name |
Type |
NULL |
Comment |
| ◆zz_row_id |
int |
☐ |
IDENTITY |
| users_id |
int |
☐ |
|
| name |
nvarchar (1024) |
☐ |
|
| question1 |
nvarchar (255) |
☐ |
|
| answer1 |
nvarchar (1024) |
☐ |
|
| question2 |
nvarchar (255) |
☐ |
|
| answer2 |
nvarchar (1024) |
☐ |
|
| question3 |
nvarchar (255) |
☐ |
|
| answer3 |
nvarchar (1024) |
☐ |
|
| question4 |
nvarchar (255) |
☐ |
|
| answer4 |
nvarchar (1024) |
☐ |
|
| question5 |
nvarchar (255) |
☐ |
|
| answer5 |
nvarchar (1024) |
☐ |
|
| question6 |
nvarchar (255) |
☐ |
|
| answer6 |
nvarchar (1024) |
☐ |
|
| question7 |
nvarchar (255) |
☐ |
|
| answer7 |
nvarchar (1024) |
☐ |
|
| question8 |
nvarchar (255) |
☐ |
|
| answer8 |
nvarchar (1024) |
☐ |
|
| question9 |
nvarchar (255) |
☐ |
|
| answer9 |
nvarchar (1024) |
☐ |
|
| checksum |
nvarchar (255) |
☐ |
|
| data |
nvarchar (2048) |
☐ |
|
| active |
smallint |
☐ |
DEFAULT ((1)) |
| trashed |
smallint |
☐ |
DEFAULT ((0)) |
| is_default |
smallint |
☐ |
DEFAULT ((0)) |
| is_system |
smallint |
☐ |
DEFAULT ((0)) |
| created_on |
datetime |
☐ |
DEFAULT (getdate()) |
| trashed_on |
datetime |
☒ |
|
| deactivated_on |
datetime |
☒ |
|
⇧Table dbo.PWD_DEFAULT_QUESTIONS
Table ID: 69575286; Created: July 27, 2014, 16:02:17; Modified: July 27, 2014, 16:07:37
| Name |
Type |
NULL |
Comment |
| ◆zz_row_id |
int |
☐ |
IDENTITY |
| question_number |
int |
☐ |
|
| question |
nvarchar (255) |
☐ |
|
⇧Table dbo.PWD_TYPES
Table ID: 66099276; Created: August 21, 2014, 12:54:20; Modified: August 21, 2014, 12:54:20
| Name |
Type |
NULL |
Comment |
| ◆zz_row_id |
int |
☐ |
IDENTITY |
| name |
nvarchar (255) |
☐ |
|
| length |
int |
☐ |
|
| active |
smallint |
☐ |
DEFAULT ((1)) |
| order_num |
smallint |
☐ |
|
| value |
smallint |
☐ |
|
⇧Table dbo.USERS
Table ID: 690101499; Created: August 25, 2014, 09:29:39; Modified: August 25, 2014, 09:29:48
| Name |
Type |
NULL |
Comment |
| ◆zz_row_id |
int |
☐ |
IDENTITY |
| username |
nvarchar (255) |
☐ |
|
| password |
nvarchar (255) |
☐ |
|
| pin |
nvarchar (255) |
☐ |
|
| created_on |
datetime |
☐ |
|
| last_login_date |
datetime |
☒ |
|
| verified |
smallint |
☐ |
DEFAULT ((0)) |
| trashed |
smallint |
☐ |
DEFAULT ((0)) |
| active |
smallint |
☐ |
DEFAULT ((1)) |
| username_aes |
nvarchar (1024) |
☐ |
|
| password_aes |
nvarchar (1024) |
☐ |
|
| pin_aes |
nvarchar (255) |
☐ |
|
| trashed_on |
datetime |
☒ |
|
| deactivated_on |
datetime |
☒ |
|