1Edu

Tables (8)

Copy Of Tbl_Article (CopyOftbl_article)

  • Role_idx (role_idx) — NOT NULL — Foreign key → Tbl_Role.Role_idx — NOT NULL
  • DB_Article_id (db_article_id2) — NOT NULL — Foreign key → Tbl_Article.DB_Article_id — NOT NULL
  • DB_user_idx (db_user_idx) — NOT NULL — Foreign key → Tbl_Article.DB_user_idx — NOT NULL

Tbl_Article (tbl_article)

  • DB_Article_id (db_article_id) — NOT NULL — Primary key — NOT NULL
  • DB_user_idx (db_user_idx) — NOT NULL — Foreign key → Tbl_User.DB_user_idx — NOT NULL
  • Article_Title (article_title) — NOT NULL — NOT NULL
  • Article_Contents (article_contents) — NOT NULL — NOT NULL
  • Article_Status (article_status) — NULL
  • Article_Date (article_date) — NOT NULL
  • Article_Answer (article_answer) — NULL

Tbl_Business (tbl_business)

  • Business_idx (business_idx) — NOT NULL — Primary key — NOT NULL
  • DB_user_idx (db_user_idx) — NOT NULL — Foreign key → Tbl_User.DB_user_idx — NOT NULL
  • Business_Name (business_name) — NULL — NOT NULL
  • Level_Test_id (business_employee) — NULL — NOT NULL
  • Business_Phone (business_phone) — NULL
  • Business_Email (business_email) — NULL
  • Business_Contents (business_contents) — NULL

Tbl_Files (tbl_files)

  • Files_name (files_name) — NOT NULL — NOT NULL
  • Files_Original_Name (files_org_name) — NOT NULL — NOT NULL
  • Files_Date (files_date) — NOT NULL
  • Files_Path (files_path) — NOT NULL

Tbl_Level_test (tbl_level_test)

  • Level_Test_idx (level_test_idx) — NOT NULL — Primary key — NOT NULL
  • DB_user_idx (db_user_idx) — NOT NULL — Foreign key → Tbl_User.DB_user_idx — NOT NULL
  • Level_Test_name (level_test_name) — NULL — NOT NULL
  • Level_Test_id (level_test_id) — NULL — NOT NULL
  • Level_Test_phone (level_test_phone) — NULL
  • Level_Test__email (level_test_email) — NULL
  • Level_Test_Date (level_test_date) — NOT NULL
  • Level_Test_My_Level (level_test_my_level) — NOT NULL
  • Level_Test_Time (level_test_time) — NOT NULL
  • Level_Test_etc (level_test_etc) — NULL
  • Level_Test_Lesson (level_test_lesson) — NOT NULL

Tbl_Role (tbl_role)

  • Role_idx (role_idx) — NOT NULL — Primary key — NOT NULL
  • User_Role_second (user_role_second) — NOT NULL
  • Aricle_Role_Notice (aricle_role_notice) — NOT NULL
  • Article_Role_Notice (article_role_notice) — NOT NULL
  • Article_Role_Event (article_role_event) — NOT NULL
  • Aricle_Role_Question (aricle_role_question) — NOT NULL
  • Aricle_Role_FaQ (aricle_role_faq) — NOT NULL
  • User_Role_first (user_role_first) — NOT NULL

Tbl_User (tbl_user)

  • DB_user_idx (db_user_idx) — NOT NULL — Primary key — NOT NULL
  • user_name — NOT NULL — NOT NULL
  • User_id (user_id) — NOT NULL — NOT NULL
  • User_password (user_password) — NOT NULL
  • User_email (user_email) — NOT NULL
  • User_eng_name (user_eng_name) — NOT NULL
  • Skipe_id (skipe_id) — NOT NULL
  • User_phone (user_phone) — NOT NULL
  • User_address (user_address) — NOT NULL

Tbl_User_role (tbl_user_role)

  • DB_user_idx (db_user_idx) — NOT NULL — Foreign key → Tbl_User.DB_user_idx — NOT NULL
  • Role_idx (role_idx) — NOT NULL — Foreign key → Tbl_Role.Role_idx — NOT NULL