르네상스 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