Database Structure

If you add Ptah to your project there are some database schema requirements. You name your tables whatever you like.

ptah_blobs

This table provides the ability to support large binary objects. It is used by the ptah.cms.blob.Blob model.

Name	Type	Null	Default	Comments
id	int	False	‘’	PK, FK ptah_nodes.id
mimetype	varchar	True	‘’
filename	varchar	True	‘’
size	int	True	0
data	blob	True

ptah_content

The ptah_content table provides a definition for base content model. It is used by the ptah.cms.Content model.

Name	Type	Null	Default	Comments
id	int	False	‘’	PK, FK ptah_nodes.id
path	varchar	True
name	varchar	True		Maxlength 255
title	varchar	True
description	varchar	True
created	datetime	True
modified	datetime	True
effective	datetime	True
expires	datetime	True
lang	varchar	True

ptah_nodes

The ptah_nodes table provides the base model for all data elements in the system. This table is used by the ptah.cms.Node model.

Name	Type	Null	Default	Comments
id	int	False	‘’	Primary key
type	varchar	True	‘’
uri	varchar	False		Maxlength=255
parent	varchar	True	‘’	FK: ptah_nodes.uri
owner	varchar	True	‘’	Principal URI
roles	text	True	‘{}’	JSON
acls	text	True	‘[]’	JSON
annotations	varchar	True	‘{}’	JSON

ptah_settings

The ptah_settings table provides key, value for internal ptah settings machinery, in particular the ptah.settings.SettingRecord model.

Name	Value	Null	Default	Comments
name	varchar	False		Primary key
value	varchar	True	‘’

ptah_tokens

The ptah_tokens table provides a space for transient tokens which are generated by application, such as password-reset tokens. You use the token service API but this table is used by ptah.token.Token model table.

Name	Value	Null	Default	Comments
id	int	False		Primary key
token	varchar	True		MaxLegnth 48
valid	datetime	True
data	varchar	True
type	varchar	True		MaxLength 48

ptah_db_versions

The ptah_db_versions table contains migration revisions information.

Name	Value	Null	Default	Comments
package	str	False		Primary key
version_num	varchar	True		MaxLegnth 32