dbo.users

Description

Properties

Name	Value
File Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	0
Created	3/6/2025 6:55:55 PM
Last Modified	3/6/2025 6:55:57 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Default	Computed	Persisted
user_id	int	4	10	0	True		False	False
username	varchar	60	0	0	False		False	False
password	varchar	20	0	0	False		False	False
first_name	varchar	30	0	0	False		False	False
last_name	varchar	200	0	0	False		False	False
gender	varchar	1	0	0	False		False	False
birthday	datetime	8	23	3	False		False	False
email	varchar	500	0	0	False		False	False
home_email	varchar	100	0	0	False		False	False
beeper_mail	varchar	100	0	0	False		False	False
icq_number	varchar	20	0	0	False		False	False
cookie_id	varchar	120	0	0	False		False	False
work_phone	varchar	20	0	0	False		False	False
home_phone	varchar	20	0	0	False		False	False
cell_phone	varchar	20	0	0	False		False	False
work_fax	varchar	20	0	0	False		False	False
home_fax	varchar	20	0	0	False		False	False
pager	varchar	25	0	0	False		False	False
address	varchar	120	0	0	False		False	False
zip	varchar	12	0	0	False		False	False
city	varchar	30	0	0	False		False	False
state	varchar	20	0	0	False		False	False
country_code	varchar	2	0	0	False		False	False
organization	varchar	80	0	0	False		False	False
position	varchar	80	0	0	False		False	False
last_login	datetime	8	23	3	False		False	False
login_state	varchar	1	0	0	False		False	False
rows_per_page	int	4	10	0	False		False	False
user_created	datetime	8	23	3	False		False	False
preferences_modified	datetime	8	23	3	False		False	False
preferences	text		0	0	False		False	False
active_user	varchar	1	0	0	False		False	False
last_access	datetime	8	23	3	False		False	False
idioma	smallint	2	5	0	False		False	False
login_expiration	datetime	8	23	3	False		False	False
cli_codigo	int	4	10	0	False		False	False
aliasname	varchar	50	0	0	False		False	False
username_old	varchar	60	0	0	False		False	False
user_time_zone	varchar	60	0	0	False	('America/Argentina/Buenos_Aires')	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__users__B9BE370EE2F11EA2	user_id	True

Foreign Keys

Name	Columns	Description
FK__users__country_c__121F8769	country_code

SQL Script

Copy

CREATE TABLE dbo.users (
  user_id int NOT NULL,
  username varchar(60) NULL,
  password varchar(20) NULL,
  first_name varchar(30) NULL,
  last_name varchar(200) NULL,
  gender varchar(1) NULL,
  birthday datetime NULL,
  email varchar(500) NULL,
  home_email varchar(100) NULL,
  beeper_mail varchar(100) NULL,
  icq_number varchar(20) NULL,
  cookie_id varchar(120) NULL,
  work_phone varchar(20) NULL,
  home_phone varchar(20) NULL,
  cell_phone varchar(20) NULL,
  work_fax varchar(20) NULL,
  home_fax varchar(20) NULL,
  pager varchar(25) NULL,
  address varchar(120) NULL,
  zip varchar(12) NULL,
  city varchar(30) NULL,
  state varchar(20) NULL,
  country_code varchar(2) NULL,
  organization varchar(80) NULL,
  position varchar(80) NULL,
  last_login datetime NULL,
  login_state varchar(1) NULL,
  rows_per_page int NULL,
  user_created datetime NULL,
  preferences_modified datetime NULL,
  preferences text NULL,
  active_user varchar(1) NULL,
  last_access datetime NULL,
  idioma smallint NULL,
  login_expiration datetime NULL,
  cli_codigo int NULL,
  aliasname varchar(50) NULL,
  username_old varchar(60) NULL,
  user_time_zone varchar(60) NULL DEFAULT ('America/Argentina/Buenos_Aires'),
  PRIMARY KEY NONCLUSTERED (user_id) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE dbo.users
  ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO

Depends On

FideDoc
dbo.country