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