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)