drupal.comment.schema.json

{
    "comment": {
        "description": "Stores comments and associated data.",
        "fields": {
            "cid": {
                "type": "serial",
                "not null": true,
                "description": "Primary Key: Unique comment ID."
            },
            "pid": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "The {comment}.cid to which this comment is a reply. If set to 0, this comment is not a reply to an existing comment."
            },
            "nid": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "The {node}.nid to which this comment is a reply."
            },
            "uid": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "The {users}.uid who authored the comment. If set to 0, this comment was created by an anonymous user."
            },
            "subject": {
                "type": "varchar",
                "length": 64,
                "not null": true,
                "default": "",
                "description": "The comment title."
            },
            "hostname": {
                "type": "varchar",
                "length": 128,
                "not null": true,
                "default": "",
                "description": "The author's host name."
            },
            "created": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "The time that the comment was created, as a Unix timestamp."
            },
            "changed": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "The time that the comment was last edited, as a Unix timestamp."
            },
            "status": {
                "type": "int",
                "unsigned": true,
                "not null": true,
                "default": 1,
                "size": "tiny",
                "description": "The published status of a comment. (0 = Not Published, 1 = Published)"
            },
            "thread": {
                "type": "varchar",
                "length": 255,
                "not null": true,
                "description": "The vancode representation of the comment's place in a thread."
            },
            "name": {
                "type": "varchar",
                "length": 60,
                "not null": false,
                "description": "The comment author's name. Uses {users}.name if the user is logged in, otherwise uses the value typed into the comment form."
            },
            "mail": {
                "type": "varchar",
                "length": 64,
                "not null": false,
                "description": "The comment author's e-mail address from the comment form, if user is anonymous, and the 'Anonymous users may\/must leave their contact information' setting is turned on."
            },
            "homepage": {
                "type": "varchar",
                "length": 255,
                "not null": false,
                "description": "The comment author's home page address from the comment form, if user is anonymous, and the 'Anonymous users may\/must leave their contact information' setting is turned on."
            },
            "language": {
                "description": "The {languages}.language of this comment.",
                "type": "varchar",
                "length": 12,
                "not null": true,
                "default": ""
            }
        },
        "indexes": {
            "comment_status_pid": [
                "pid",
                "status"
            ],
            "comment_num_new": [
                "nid",
                "status",
                "created",
                "cid",
                "thread"
            ],
            "comment_uid": [
                "uid"
            ],
            "comment_nid_language": [
                "nid",
                "language"
            ],
            "comment_created": [
                "created"
            ]
        },
        "primary key": [
            "cid"
        ],
        "foreign keys": {
            "comment_node": {
                "table": "node",
                "columns": {
                    "nid": "nid"
                }
            },
            "comment_author": {
                "table": "users",
                "columns": {
                    "uid": "uid"
                }
            }
        }
    },
    "node_comment_statistics": {
        "description": "Maintains statistics of node and comments posts to show \"new\" and \"updated\" flags.",
        "fields": {
            "nid": {
                "type": "int",
                "unsigned": true,
                "not null": true,
                "default": 0,
                "description": "The {node}.nid for which the statistics are compiled."
            },
            "cid": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "The {comment}.cid of the last comment."
            },
            "last_comment_timestamp": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "The Unix timestamp of the last comment that was posted within this node, from {comment}.changed."
            },
            "last_comment_name": {
                "type": "varchar",
                "length": 60,
                "not null": false,
                "description": "The name of the latest author to post a comment on this node, from {comment}.name."
            },
            "last_comment_uid": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "The user ID of the latest author to post a comment on this node, from {comment}.uid."
            },
            "comment_count": {
                "type": "int",
                "unsigned": true,
                "not null": true,
                "default": 0,
                "description": "The total number of comments on this node."
            }
        },
        "primary key": [
            "nid"
        ],
        "indexes": {
            "node_comment_timestamp": [
                "last_comment_timestamp"
            ],
            "comment_count": [
                "comment_count"
            ],
            "last_comment_uid": [
                "last_comment_uid"
            ]
        },
        "foreign keys": {
            "statistics_node": {
                "table": "node",
                "columns": {
                    "nid": "nid"
                }
            },
            "last_comment_author": {
                "table": "users",
                "columns": {
                    "last_comment_uid": "uid"
                }
            }
        }
    }
}