1st
Tables (15)
business_partnership (Untitled)
- business_partnership_id (Key) — auto_increment — Primary key — NOT NULL
- company_name (Field) — char
- company_manager_name (Field2) — char
- company_contact_phone_number (Field3) — int
- company_email (Field4) — char
- company_detail (Field5) — cahr
company_members (CopyOfCopyOfCopyOfCopyOfUntitled223)
- company_member_id (Key) — auto_increment — Primary key — NOT NULL
- company_role_id (Key2) — auto_increment — Foreign key → company_roles.company_role_id — NOT NULL
- member_id (Key3) — auto_increment — Foreign key → members.member_id — NOT NULL
company_roles (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled223)
- company_role_id (Key) — auto_increment — Primary key — NOT NULL
- company_role_name (Field) — char
contact_us (CopyOfCopyOfCopyOfUntitled2)
- contact_us_id (Key) — auto_increment — Primary key — NOT NULL
- member_id (Key2) — auto_increment — Foreign key → members.member_id — NOT NULL
- contact_us_title (Field) — char
- contact_us_contents (Field2) — char
- contact_us_views (Field3) — int
- contact_us_comments_flag (Field4) — bool
- contact_us_create_date (Field5) — date
- contact_us_update_date (Field6) — date
contact_us_comments (CopyOfCopyOfCopyOfCopyOfUntitled22)
- contact_us_comment_id (Key) — auto_increment — Primary key — NOT NULL
- contact_us_id (Key2) — auto_increment — Foreign key → contact_us.contact_us_id — NOT NULL
- member_id (Key3) — auto_increment — Foreign key → members.member_id — NOT NULL
- contents (Field2) — char
course_payments (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- course_payment_id (Key) — auto_increment — Primary key — NOT NULL
- course_payment_name (Field) — char
- course_payment_price (Field2) — int
- course_payment_term (Field3) — date
course_review_comments (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled22)
- course_review_comment_id (Key) — auto_increment — Primary key — NOT NULL
- course_review_id (Key2) — auto_increment — Foreign key → course_reviews.course_review_id — NOT NULL
- member_id (Key3) — auto_increment — Foreign key → members.member_id — NOT NULL
- contents (Field2) — char
course_reviews (CopyOfCopyOfCopyOfCopyOfUntitled2)
- course_review_id (Key) — auto_increment — Primary key — NOT NULL
- member_id (Key2) — auto_increment — Foreign key → members.member_id — NOT NULL
- course_review_title (Field) — char
- course_review_contents (Field2) — char
- course_review_views (Field3) — int
- course_review_comments_flag (Field4) — bool
- course_review_is_top_flag (Field7) — bool
- course_review_create_date (Field5) — date
- course_review_update_date (Field6) — date
course_schedules (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- course_schedule_id (Key) — auto_increment — Primary key — NOT NULL
- member_id (Key3) — auto_increment — Foreign key → members.member_id — NOT NULL
- company_member_id (Key2) — auto_increment — Foreign key → company_members.company_member_id — NOT NULL
- course_payment_id (Key4) — auto_increment — Foreign key → course_payments.course_payment_id — NOT NULL
- course_register_date (Field4) — date
- course_active_flag (Field5) — bool
- course_start_date (Field6) — date
- course_end_date (Field7) — date
free_lesson (CopyOfUntitled)
- free_lesson_id (Key) — auto_increment — Primary key — NOT NULL
- member_id (Key3) — auto_increment — Foreign key → members.member_id — NOT NULL
- free_lesson_role_id (Key2) — int — Foreign key → free_lesson_role.free_lesson_role_id — NOT NULL
- free_name (Field2) — char
- free_phone_number (Field3) — char
- free_email (Field4) — char
- free_address_detail (Field5) — char
- free_address (Field6) — char
- free_type (Field8) — char
- free_start_date (Field9) — date
free_lesson_role (CopyOfCopyOfUntitled)
- free_lesson_role_id (Key) — int — Primary key — NOT NULL
- free_lesson_role_name (Field7) — char
members (CopyOfCopyOfCopyOfUntitled22)
- member_id (Key) — auto_increment — Primary key — NOT NULL
- member_user_id (Field) — char
- member_user_pw (Field2) — char
- member_salt (Field3) — char
- member_ko_name (Field4) — char
- member_en_name (Field5) — char
- member_phone_number (Field6) — int
- member_email (Field7) — char
- member_address (Field8) — char
- member_address_detail (Field9) — char
- member_skipe_id (Field10) — char
- member_course_flag (Field11) — bool
- member_course_id (Field13) — bigint
- member_register_date (Field12) — date
- member_update-date (Field14) — date
notices (CopyOfCopyOfUntitled2)
- notice_id (Key) — auto_increment — Primary key — NOT NULL
- notice_title (Field) — char
- notice_contents (Field2) — char
- notice_views (Field3) — int
- notice_is_top_flag (Field4) — bool
- notice_create_date (Field5) — date
- notice_update_date (Field6) — date
- company_member_id (Key2) — auto_increment — Foreign key → company_members.company_member_id — NOT NULL
payments (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- payment_id (Key) — auto_increment — Primary key — NOT NULL
- course_payment_id (Key2) — auto_increment — Foreign key → course_payments.course_payment_id — NOT NULL
- member_id (Key3) — auto_increment — Foreign key → members.member_id — NOT NULL
- payment_type (Field) — char
- payment_price (Field2) — int
points (CopyOfCopyOfCopyOfCopyOfUntitled222)
- member_point_id (Key) — auto_increment — Primary key — NOT NULL
- member_id (Key2) — auto_increment — Foreign key → members.member_id — NOT NULL
- member_point (Field) — defalut 0