르네상스 Star Reading

테이블 (11)

Class (class_tb)

  • code — int(5) — 기본 키 — NOT NULL
  • member code (mem_code) — int(5) — 외래 키 → Member.code — NOT NULL
  • class name (class_name) — varchar(20)
  • class room (class_room) — varchar(20)
  • date (reg_date) — datatime

Counsel (counsel_tb)

  • code — int(5) — 기본 키 — NOT NULL
  • student code (stu_code) — int(5) — 외래 키 → Student.code — NOT NULL
  • title (name) — varchar(200)
  • content (cost) — varchar(50)
  • product info (info)

Exam Content (exam_content_tb)

  • code — int(5) — 기본 키 — NOT NULL
  • level (type) — varchar(10)
  • question area (q_area) — varchar(20)
  • question sub area (q_sub_area) — varchar(20)
  • question type (q_type) — varchar(10)
  • question (q_text)
  • answer (q_answer) — varchar(50)
  • date (reg_date) — datatime

Faq (faq_tb)

  • code — int(5) — 기본 키 — NOT NULL
  • title — varchar(200)
  • content (class_room)
  • date (reg_date) — datatime

Member (member_tb)

  • code — int(5) — 기본 키 — NOT NULL
  • id — varchar(50)
  • member name (comp_name) — varchar(50)
  • country — varchar(50)
  • area (area_name) — varchar(50)
  • tel — varchar(20)
  • Fax (fax) — varchar(20)
  • date (reg_date) — datatime

Notice (notice_tb)

  • code — int(5) — 기본 키 — NOT NULL
  • title — varchar(200)
  • content (class_room)
  • date (reg_date) — datatime

Payment (payment_tb)

  • code — int(5) — 기본 키 — NOT NULL
  • member code (mem_code) — int(5) — 외래 키 → Member.code — NOT NULL
  • student code (stu_code) — int(5) — 외래 키 → Student.code — NOT NULL
  • product code (pro_code) — int(5) — 외래 키 → Product.code — NOT NULL
  • product name (product_name) — varchar(50)
  • cost — int(5)
  • payment info (pay_info)
  • payment state (state) — varchar(10)
  • payment date (reg_date) — datatime

Product (product_tb)

  • code — int(5) — 기본 키 — NOT NULL
  • product_name (name) — varchar(50)
  • cost — int(5)
  • exam_cnt (cnt) — int(5)
  • product info (info)

Student (student_tb)

  • code — int(5) — 기본 키 — NOT NULL
  • member code (mem_code) — int(5) — 외래 키 → Member.code — NOT NULL
  • class code (class_code) — int(5) — 외래 키 → Class.code — NOT NULL
  • B2B / B2C type (type) — varchar(10)
  • student id (student_id) — varchar(50)
  • student name (student_name) — varchar(50)
  • e-mail (email) — varchar(100)
  • area (area_name) — varchar(50)
  • tel — varchar(20)
  • date (reg_date) — datatime

Student Exam Count (student_exam_cnt_tb)

  • code — int(5) — 기본 키 — NOT NULL
  • member code (mem_code) — int(5) — 외래 키 → Member.code — NOT NULL
  • student code (stu_code) — int(5) — 외래 키 → Student.code — NOT NULL
  • payment code (pay_code) — int(5) — 외래 키 → Payment.code — NOT NULL
  • exam key (exam_key) — varchar(20)

Student Exam Result (student_exam_result_tb)

  • code — int(5) — 기본 키 — NOT NULL
  • exam key (exam_key) — varchar(20) — 외래 키 → Student Exam Count.code — NOT NULL
  • member code (mem_code) — int(5) — 외래 키 → Member.code — NOT NULL
  • student code (stu_code) — int(5) — 외래 키 → Student.code — NOT NULL
  • SS (ss) — int(5)
  • PR (pr) — int(5)
  • GE (ge) — varchar(10)
  • IRL (irl) — varchar(10)
  • Est. ORF (orf) — int(5)
  • Literature 1 (literature_1) — int(5)
  • Literature 2 (literature_2) — int(5)
  • Infomational 1 (infomational_1) — int(5)
  • Infomational 2 (infomational_2) — int(5)
  • Infomational 3 (infomational_3) — int(5)
  • Vocabulary (vocabulary_1) — int(5)
  • ZPD (zpd) — varchar(10)
  • date (reg_date) — datatime