workHelp
Tables (6)
bookmark (Untitled)
- b_id (Key) — bigint — Primary key — NOT NULL
- b_name (Field) — varchar(200) — NOT NULL
- b_url (Field2) — varchar(3000) — NOT NULL
- b_info (Field3) — varchar(10000) — NOT NULL
- b_status (Field4) — int — NOT NULL
- m_id (Key2) — varchar(30) — Foreign key → member.m_id — NOT NULL
issue_tree (Untitled8)
- i_id (Key) — bigint — Primary key — NOT NULL
- m_id (Key2) — varchar(30) — Foreign key → member.m_id — NOT NULL
- t_pid (Field) — bigint — NOT NULL
- i_isleaf (Field2) — tinyint — NOT NULL
- i_title (Field3) — varchar(200) — NOT NULL
- i_status (Field4) — int — NOT NULL
- i_content (Field5) — text — NOT NULL
- i_result (Field6) — text — NOT NULL
- i_start (Field7) — Date — NOT NULL
- i_end (Field8) — Date — NOT NULL
- i_date (Field9) — Date — NOT NULL
member
- m_id (Key) — varchar(30) — Primary key — NOT NULL
- m_name (Field) — varchar(30) — NOT NULL
- m_pw (Field2) — varchar(200) — NOT NULL
- regdate (Field3) — Date — NOT NULL
- urole (Field7) — int — NOT NULL
- m_status (Field6) — int — NOT NULL
- m_aid (Field4) — varchar(30) — NOT NULL
member_token (CopyOfUntitled4)
- m_id (Key) — varchar(30) — Foreign key → member.m_id — NOT NULL
- token (Field) — varchar(2000) — NOT NULL
- mt_status (Field2) — int — NOT NULL
todo_list (Untitled2)
- td_id (Key) — long — Primary key — NOT NULL
- td_title (Field) — varchar(200) — NOT NULL
- td_status (Field6) — int — NOT NULL
- m_id (Key2) — varchar(30) — Foreign key → member.m_id — NOT NULL
- td_content (Field2) — text
- td_start (Field3) — date — NOT NULL
- td_end (Field4) — date — NOT NULL
- i_id (Key3) — bigint — Foreign key → issue_tree.i_id — NOT NULL
- td_result (Field5) — int — NOT NULL
url_tree (Untitled6)
- u_id (Key) — bigint — Primary key — NOT NULL
- u_title (Field) — varchar(200) — NOT NULL
- u_pid (Field2) — bigint — NOT NULL
- u_isleaf (Field3) — int — NOT NULL
- u_state (Field4) — int — NOT NULL
- m_id (Key2) — varchar(30) — Foreign key → member.m_id — NOT NULL
- u_content (Field5) — text — NOT NULL
- u_url (Field6) — varchar(3000) — NOT NULL