Untitled
Tables (12)
TableA
- IDA — INT — Primary key — NOT NULL
- IDB — INT — Primary key — NOT NULL
- Content — VARCHAR(45)
- Date — TIMESTAMP
TableB
- IDX — INT — Foreign key → TableA.IDA — NOT NULL
- IDZ — INT — Foreign key → TableA.IDB
- Content — VARCHAR(45)
- Date — TIMESTAMP
blog_author
- id — INT — Primary key — NOT NULL
- display_name — VARCHAR(45) — NOT NULL
- first_name — VARCHAR(45)
- last_name — VARCHAR(45)
blog_category
- id — INT — Primary key — NOT NULL
- name — VARCHAR(45) — NOT NULL
- name_clean — VARCHAR(45)
- enabled — TINYINT — NOT NULL
- date_created — TIMESTAMP
blog_comment
- id — INT — Primary key — NOT NULL
- post_id — INT — Foreign key → blog_post.id — NOT NULL
- is_reply_to_id — INT — NOT NULL
- comment_content — TEXT — NOT NULL
- user_id — INT — Foreign key → blog_user.user_id
- mark_read — TINYINT(1)
- enabled — TINYINT(1) — NOT NULL
- comment_date — TIMESTAMP
blog_post
- id — INT — Primary key — NOT NULL
- title — VARCHAR(144) — NOT NULL
- article — TEXT
- title_clean — VARCHAR(144)
- file — VARCHAR(45)
- author_id — INT — Foreign key → blog_author.id
- date_published — TIMESTAMP — NOT NULL
- banner_image — VARCHAR(144)
- featured — TINYINT(1) — NOT NULL
- enabled — TINYINT(1) — NOT NULL
- comments_enabled — TINYINT(1) — NOT NULL
- views — INT — NOT NULL
blog_post_to_category
- category_id — INT — Foreign key → blog_category.id — NOT NULL
- post_id — INT — Foreign key → blog_post.id — NOT NULL
blog_related
- blog_post_id — INT — Foreign key → blog_post.id — NOT NULL
- blog_related_post_id — INT — NOT NULL
blog_tag
- id — INT — Primary key — NOT NULL
- post_id — INT — Foreign key → blog_post.id — NOT NULL
- tag — VARCHAR(45) — NOT NULL
- tag_clean — VARCHAR(45) — NOT NULL
blog_user
- user_id — INT — Primary key — NOT NULL
- name — VARCHAR(45)
- email — VARCHAR(45)
blog_user_detail
- user_id — INT — Foreign key → blog_user.user_id — NOT NULL
- phonenumber — VARCHAR(11)
- website — VARCHAR(45)
- user_picture — VARCHAR(45)