board

Tables (6)

Admin (Untitled)

  • id — int — Primary key — NOT NULL
  • afreecatv_id — varchar(50) — NOT NULL
  • enroll_id — varchar(50)
  • enroll_date — datetime — NOT NULL

Image (Untitled2)

  • id — int — Primary key — NOT NULL
  • post_id — int — Foreign key → Post.id — NOT NULL
  • image_name — varchar(256) — NOT NULL

Post (Untitled3)

  • id — int — Primary key — NOT NULL
  • is_notice — tinyint — NOT NULL — 공지글 1 일반글 0
  • user_name — varchar(50) — NOT NULL — 아프리카tv 유저 ID
  • user_id — int — NOT NULL
  • title — varchar(50) — NOT NULL
  • content — text
  • date — datetime — NOT NULL
  • up — int — NOT NULL
  • visit — int — NOT NULL
  • reply_count — int

Post_up (Untitled5)

  • id — int — Primary key — NOT NULL
  • user_id — int — NOT NULL
  • post_id — int — NOT NULL

Reply (CopyOfUntitled3)

  • id — int — Primary key — NOT NULL
  • post_id — int — Foreign key → Post.id — NOT NULL
  • parent_id — int — NOT NULL — 부모의 인덱스
  • type — varchar(10) — NOT NULL — 게시글인지, 댓글인지, 답글인지 판단
  • content — text — NOT NULL
  • image_name — varchar(256)
  • user_id — int — NOT NULL
  • user_name — varchar(50) — NOT NULL — 사용자 닉네임
  • is_admin — tinyint — NOT NULL
  • date — datetime — NOT NULL
  • up — int — NOT NULL
  • rereply_count — int

Reply_up (CopyOfUntitled5)

  • id — int — Primary key — NOT NULL
  • user_id — int — NOT NULL
  • reply_id — int — NOT NULL
  • type — varchar(10)