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