Print view - phpMyAdmin 4.8.4

companies

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	bigint(20)	No
createdate	datetime	Yes	NULL
domain	varchar(255)	Yes	NULL
hs_lastmodifieddate	datetime	Yes	NULL
hs_object_id	bigint(20)	Yes	NULL
name	varchar(255)	Yes	NULL
createdAt	datetime	Yes	NULL
updatedAt	datetime	Yes	NULL
archived	tinyint(1)	Yes	NULL
url	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	13320	A	No

contacts

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	varchar(50)	No
createdAt	timestamp	No	CURRENT_TIMESTAMP
updatedAt	timestamp	No	0000-00-00 00:00:00
archived	tinyint(1)	Yes	NULL
url	text	Yes	NULL
createdate	timestamp	No	0000-00-00 00:00:00
email	varchar(255)	Yes	NULL
firstname	varchar(100)	Yes	NULL
hs_object_id	varchar(50)	Yes	NULL
lastmodifieddate	timestamp	No	0000-00-00 00:00:00
lastname	varchar(100)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	93149	A	No

deals

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	bigint(20)	No
description	varchar(255)	Yes	NULL
deal_produk	varchar(255)	Yes	NULL
amount	decimal(18,2)	Yes	NULL
createdate	datetime	Yes	NULL
dealname	varchar(255)	Yes	NULL
dealstage	varchar(100)	Yes	NULL
hs_lastmodifieddate	datetime	Yes	NULL
hs_object_id	bigint(20)	Yes	NULL
hubspot_owner_id	bigint(20)	Yes	NULL
createdAt	datetime	Yes	NULL
updatedAt	datetime	Yes	NULL
archived	tinyint(1)	Yes	NULL
url	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	40993	A	No

Open new phpMyAdmin window