iu_laonboard
Tables (17)
autosaves
- id — INT(10) — Primary key — NOT NULL
- user_id — INT(11) — NOT NULL
- unique_id — VARCHAR(50) — NOT NULL
- subject — VARCHAR(255)
- content — TEXT
- created_at — TIMESTAMP
board_files
- board_id — INT(11) — Primary key — NOT NULL
- write_id — INT(11) — Primary key — NOT NULL
- board_file_no — INT(11) — Primary key — NOT NULL
- source — VARCHAR(255) — NOT NULL
- file — VARCHAR(255) — NOT NULL
- download — INT(11) — NOT NULL
- content — TEXT
- filesize — INT(11) — NOT NULL
- width — INT(11) — NOT NULL
- height — SMALLINT(6) — NOT NULL
- type — TINYINT(4) — NOT NULL
- created_at — TIMESTAMP
board_goods
- id — INT(10) — Primary key — NOT NULL
- board_id — INT(11) — NOT NULL
- write_id — INT(11) — NOT NULL
- user_id — INT(11) — NOT NULL
- flag — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
board_news
- id — INT(10) — Primary key — NOT NULL
- board_id — INT(10) — NOT NULL
- write_id — INT(10) — NOT NULL
- write_parent — INT(10) — NOT NULL
- created_at — TIMESTAMP
- user_id — INT(10) — NOT NULL
boards
- id — INT(10) — Primary key — NOT NULL
- table_name — VARCHAR(20) — NOT NULL
- group_id — INT(10) — NOT NULL
- subject — VARCHAR(255) — NOT NULL
- mobile_subject — VARCHAR(255)
- device — ENUM('both','pc','mobile') — NOT NULL
- admin — VARCHAR(255)
- list_level — TINYINT(4) — NOT NULL
- read_level — TINYINT(4) — NOT NULL
- write_level — TINYINT(4) — NOT NULL
- reply_level — TINYINT(4) — NOT NULL
- comment_level — TINYINT(4) — NOT NULL
- upload_level — TINYINT(4) — NOT NULL
- download_level — TINYINT(4) — NOT NULL
- html_level — TINYINT(4) — NOT NULL
- link_level — TINYINT(4) — NOT NULL
- count_delete — TINYINT(4) — NOT NULL
- count_modify — TINYINT(4) — NOT NULL
- read_point — INT(11) — NOT NULL
- write_point — INT(11) — NOT NULL
- comment_point — INT(11) — NOT NULL
- download_point — INT(11) — NOT NULL
- use_category — TINYINT(4) — NOT NULL
- category_list — TEXT
- use_sideview — TINYINT(4) — NOT NULL
- use_file_content — TINYINT(4) — NOT NULL
- use_secret — TINYINT(4) — NOT NULL
- use_dhtml_editor — TINYINT(4) — NOT NULL
- use_rss_view — TINYINT(4) — NOT NULL
- use_recaptcha — TINYINT(4) — NOT NULL
- use_good — TINYINT(4) — NOT NULL
- use_nogood — TINYINT(4) — NOT NULL
- use_name — TINYINT(4) — NOT NULL
- use_signature — TINYINT(4) — NOT NULL
- use_ip_view — TINYINT(4) — NOT NULL
- use_list_view — TINYINT(4) — NOT NULL
- use_list_file — TINYINT(4) — NOT NULL
- use_list_content — TINYINT(4) — NOT NULL
- table_width — INT(11) — NOT NULL
- subject_len — INT(11) — NOT NULL
- mobile_subject_len — INT(11) — NOT NULL
- page_rows — INT(11) — NOT NULL
- mobile_page_rows — INT(11) — NOT NULL
- new — INT(11) — NOT NULL
- hot — INT(11) — NOT NULL
- image_width — INT(11) — NOT NULL
- skin — VARCHAR(255)
- mobile_skin — VARCHAR(255)
- layout — VARCHAR(255)
- content_head — TEXT
- mobile_content_head — TEXT
- content_tail — TEXT
- mobile_content_tail — TEXT
- insert_content — TEXT
- gallery_cols — INT(11) — NOT NULL
- gallery_width — INT(11) — NOT NULL
- gallery_height — INT(11) — NOT NULL
- mobile_gallery_width — INT(11) — NOT NULL
- mobile_gallery_height — INT(11) — NOT NULL
- upload_size — INT(11) — NOT NULL
- … +16
configs
- id — INT(10) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- vars — TEXT — NOT NULL
group_user
- id — INT(10) — Primary key — NOT NULL
- user_id — INT(10) — NOT NULL
- group_id — INT(10) — NOT NULL
- created_at — DATETIME — NOT NULL
groups
- id — INT(10) — Primary key — NOT NULL
- group_id — VARCHAR(10) — NOT NULL
- subject — VARCHAR(255) — NOT NULL
- device — ENUM('both','pc','mobile') — NOT NULL
- admin — VARCHAR(255)
- use_access — TINYINT(4)
- order — INT(11)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
manage_auth
- id — INT(10) — Primary key — NOT NULL
- user_id — INT(10) — NOT NULL
- menu — VARCHAR(50) — NOT NULL
- auth — SET('r','w','d')
- isModule — TINYINT(3) — NOT NULL
memos
- id — INT(10) — Primary key — NOT NULL
- recv_user_id — INT(10) — NOT NULL
- send_user_id — INT(10) — NOT NULL
- send_timestamp — TIMESTAMP
- read_timestamp — TIMESTAMP
- memo — TEXT — NOT NULL
- INDEX — `memos_recv_user_id_index`
menus
- id — INT(10) — Primary key — NOT NULL
- code — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- link — VARCHAR(255) — NOT NULL
- target — VARCHAR(255) — NOT NULL
- order — INT(11) — NOT NULL
- use — TINYINT(4) — NOT NULL
- mobile_use — TINYINT(4) — NOT NULL
migrations
- id — INT(10) — Primary key — NOT NULL
- migration — VARCHAR(255) — NOT NULL
- batch — INT(11) — NOT NULL
password_resets
- email — VARCHAR(50) — NOT NULL
- token — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
points
- id — INT(10) — Primary key — NOT NULL
- user_id — INT(10) — NOT NULL
- datetime — TIMESTAMP
- content — VARCHAR(255)
- point — INT(11)
- use_point — INT(11)
- expired — TINYINT(4) — NOT NULL
- expire_date — DATE
- user_point — INT(11)
- rel_table — VARCHAR(20)
- rel_email — VARCHAR(50)
- rel_action — VARCHAR(255)
scraps
- id — INT(10) — Primary key — NOT NULL
- user_id — INT(10) — NOT NULL
- board_id — INT(10) — NOT NULL
- write_id — INT(10) — NOT NULL
- created_at — TIMESTAMP
social_logins
- id — INT(10) — Primary key — NOT NULL
- provider — VARCHAR(20)
- social_id — VARCHAR(255)
- social_token — TEXT
- ip — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- user_id — INT(10)
users
- id — INT(10) — Primary key — NOT NULL
- name — VARCHAR(255)
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(60)
- nick — VARCHAR(255) — NOT NULL
- nick_date — DATE
- homepage — VARCHAR(255)
- level — TINYINT(4)
- sex — CHAR(1)
- birth — VARCHAR(255)
- tel — VARCHAR(255)
- hp — VARCHAR(255)
- certify — VARCHAR(20)
- adult — TINYINT(4)
- dupinfo — VARCHAR(255)
- zip — CHAR(5)
- addr1 — VARCHAR(255)
- addr2 — VARCHAR(255)
- addr_jibeon — VARCHAR(255)
- signature — TEXT
- recommend — INT(10)
- point — INT(11)
- today_login — TIMESTAMP — NOT NULL
- login_ip — VARCHAR(255)
- ip — VARCHAR(255)
- leave_date — VARCHAR(8)
- intercept_date — VARCHAR(8)
- email_certify — TIMESTAMP
- email_certify2 — VARCHAR(255)
- memo — TEXT
- lost_certify — VARCHAR(255)
- mailing — TINYINT(4)
- sms — TINYINT(4)
- open — TINYINT(4)
- open_date — DATE
- profile — TEXT
- memo_call — VARCHAR(255)
- id_hashkey — VARCHAR(255)
- remember_token — VARCHAR(100)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP