commu

Tables (10)

Copy Of Untitled (favorite_article)

  • Key (article_idx) — int(11) — Primary key — NOT NULL
  • Key (user_idx) — int(11)unsigned — Foreign key → Untitled.Key — NOT NULL
  • Key (board_idx) — int(11)unsigned — Foreign key → Untitled.Key — NOT NULL
  • Field (create_at) — char(20)

Copy Of Untitled2 (account_admin)

  • Key (user_idx) — int(11)unsigned — Primary key — NOT NULL
  • Field (user_id) — varchar(40)
  • Field2 (password) — varchar(100)
  • Field (status) — int(5)
  • Field (user_agent) — varchar(250)
  • Field (admin) — varchar(100) — 이 부분은 정확히 어떤 내용이 들어갈 지 미정입니다. 추후 관리자 페이지에 대해서 생각중인데 예를 들어 댓글을 보고 블락처리 같은 걸 하는 식으로 페이지를 구성한다면 따로 관리자 관련 테이블을 두는 게 아니고 기존…
  • Field (intro) — text
  • Field (intro_en) — text
  • Field (intro_ja) — text
  • Field (nickname) — varchar(40)

Copy Of Untitled3 (bug_report)

  • Key (idx) — int(11)unsigned — Foreign key → Untitled.Key — NOT NULL
  • Field (article_idx) — int(11)unsigned
  • Field (content) — varchar(255)
  • Field (opinion) — varchar(255)
  • Field (user-agent) — varchar(255)
  • Field (ip_address) — varchar(50)
  • Field (nickname) — varchar(50)

Untitled (account_user)

  • Key (user_idx) — int(11)unsigned — Primary key — NOT NULL — article 연결해야 됨
  • Field (user_id) — varchar(40)
  • Field2 (password) — varchar(100)
  • Field (nickname) — varchar(40)
  • Field3 (email) — varchar(50)
  • Field (oshi) — varchar(20)
  • Field (status) — char(1) — 이 부분은 계정에 대한 패널티 부분 ex) 1 = 유저 2 = 3일 활동 정지 3 = 7일 활동 정지 7 = 블랙리스트
  • Field (user_agent) — varchar(250)
  • Field (create_at) — char(20)
  • Field (delete_at) — char(20)
  • Field (update_at) — char(20)

Untitled (favorite_tag)

  • Key (tag_idx) — int(11) — Primary key — NOT NULL
  • Key (user_idx) — int(11)unsigned — Foreign key → Untitled.Key — NOT NULL
  • Field (tag) — varchar(255)

Untitled (article)

  • Key (board_idx) — int(11)unsigned — Primary key — NOT NULL
  • Key (user_idx) — int(11)unsigned — Foreign key → Copy Of Untitled2.Key — NOT NULL
  • Field (status) — char(1)
  • Field (hit) — varchar(10)
  • Field (category) — varchar(40)
  • Field (translate_en_date) — varchar(16)
  • Field (translate_ja_date) — varchar(16)
  • Field (translate_en_check) — char(1)
  • Field (translate_ja_check) — char(1)
  • Field (tags) — varchar(100)
  • Field (tags_en) — varchar(100)
  • Field (tags_ja) — varchar(100)
  • Field (title) — varchar(255)
  • Field (title_en) — varchar(255)
  • Field (title_ja) — varchar(255)
  • Field (content) — text
  • Field (content_en) — text
  • Field (content_ja) — text
  • Field (alt) — text
  • Field (alt_en) — text
  • Field (alt_ja) — text
  • Field (memo) — text
  • Field (create_at) — char(20)
  • Field (delete_at) — char(20)
  • Field (updated_at) — char(20)

Untitled (article_relation)

  • Key (board_idx) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (type) — char(5)
  • Field (link) — varchar(255)
  • Field (title) — varchar(255)
  • Field (title_en) — varchar(255)
  • Field (title_ja) — varchar(255)
  • Field (author) — varchar(255)

Untitled (social)

  • Key (user_idx) — int(11)unsigned — Foreign key → Untitled.Key — NOT NULL
  • Field (kakao) — varchar(50)
  • Field (twitter) — varchar(50)
  • Field (google) — varchar(50)
  • Field (facebook) — varchar(50)

Untitled (article_comment)

  • Key (comment_idx) — int(11)unsigned — Primary key — NOT NULL
  • Key (user_idx) — int(11)unsigned — Foreign key → Untitled.Key — NOT NULL
  • Key (board_idx) — int(11)unsigned — Foreign key → Untitled.Key — NOT NULL
  • Field (create_at) — char(20)
  • Field (delete_at) — char(20)
  • Field (updated_at) — char(20)
  • Field (comment) — varchar(100)

Untitled (nodemailer)

  • Key (idx) — int(5) — Primary key — NOT NULL
  • Field (mail) — varchar(40)
  • Field (random_number) — varchar(40)
  • Field (create_at) — varchar(40)
  • Field (retries) — char(1)
  • Field (expiry_at) — varchar(40)
  • Field (success) — tinyint(1)