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)