SSSSSSSSSS
Tables (9)
categories
- id — int(10) — Primary key — NOT NULL
- parent_id — int(10)
- name — varchar(255) — NOT NULL
- detail — text
- count — int(10) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
comments
- id — int(10) — Primary key — NOT NULL
- parent_id — int(10)
- user_id — int(10)
- name — varchar(255)
- password — varchar(60)
- comment — text — NOT NULL
- approved — tinyint(1) — NOT NULL
- target — enum('posts', 'notices') — NOT NULL
- post_id — int(10)
- notice_id — int(10)
- ip — varchar(45) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- id (id2) — int(10) — Foreign key → notices.id — NOT NULL
files
- id — int(10) — Primary key — NOT NULL
- path — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- original_name — varchar(255) — NOT NULL
- extension — varchar(10) — NOT NULL
- download_count — int(10) — NOT NULL
- target — enum('posts', 'notices') — NOT NULL
- notice_id — int(10)
- post_id — int(10)
- created_at — timestamp
- updated_at — timestamp
guestbooks
- id — int(10) — Primary key — NOT NULL
- parent_id — int(10)
- user_id — int(10)
- name — varchar(255)
- password — varchar(60)
- comment — text — NOT NULL
- created_at — timestamp
- updated_at — timestamp
notices
- id — int(10) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- accept_comment — tinyint(1) — NOT NULL
- approved — tinyint(1) — NOT NULL
- hit — int(10) — NOT NULL
- count — int(10) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
post_tag
- post_id — int(10) — Foreign key → posts.id — NOT NULL
- tag_id — int(10) — Foreign key → tags.id — NOT NULL
posts
- id — int(10) — Primary key — NOT NULL
- category_id — int(10) — NOT NULL
- title — varchar(255) — NOT NULL
- body — text — NOT NULL
- image_path — varchar(255)
- image_name — varchar(255)
- slug — varchar(255) — NOT NULL
- accept_comment — tinyint(1) — NOT NULL
- approved — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
tags
- id — int(10) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- count — int(10) — NOT NULL
- created_at — timestemp
- updated_at — timestamp
users
- id — int(10) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(60) — NOT NULL
- created_at — timestamp
- updated_at — timestamp