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