1
Tables (9)
anpracticeposts
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- author — varchar(255) — NOT NULL
- content — text — NOT NULL
- created_at — timestamp — NOT NULL
- views — int
ceposts
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- author — varchar(255) — NOT NULL
- content — text — NOT NULL
- created_at — timestamp — NOT NULL
- views — int
cnpracticeposts
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- author — varchar(255) — NOT NULL
- content — text — NOT NULL
- created_at — timestamp — NOT NULL
- views — int
comment
- id — int — Primary key — NOT NULL
- board_id — int — Foreign key → posts.id
- author — varchar(255) — NOT NULL
- content — text — NOT NULL
- created_at — timestamp — NOT NULL
dhtml_content
- id — int — Primary key — NOT NULL
- post_id — int — Foreign key → record_board.id
- record_type — int — Foreign key → record_type.type_id
- dhtml_data — longtext
posts
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- author — varchar(255) — NOT NULL
- content — text — NOT NULL
- created_at — timestamp — NOT NULL
- views — int
record_board
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- author — varchar(255) — NOT NULL
- record_type — int — Foreign key → record_type.type_id
- created_at — timestamp — NOT NULL
- image_path — varchar(1024)
- totalscore — int
record_type
- type_id — int — Primary key — NOT NULL
- type_name — varchar(255) — NOT NULL
- type_image_path — varchar(1024) — NOT NULL
- type_thumnail_image_path — varchar(1024) — NOT NULL
- dhtml_content — text — NOT NULL
user
- id — varchar(50) — NOT NULL
- pw — varchar(50) — NOT NULL
- name — varchar(50) — NOT NULL
- level — int — NOT NULL — 권한레벨
- admin — enum('Y', 'N') — NOT NULL — 관리자여부
- grouplevel — varchar(50)