CodeOClock
Tables (23)
Admin
- ad_id — VARCHAR(40) — Primary key — NOT NULL
- ad_pass — VARCHAR(40)
- ad_tel — VARCHAR(40)
- ad_post — CHAR(5)
- ad_addr — VARCHAR(80)
- ad_addr_sub — VARCHAR(80)
- ad_email — VARCHAR(40)
Announcement
- an_id — INTEGER — Primary key — NOT NULL
- an_title — VARCHAR(40)
- an_content — VARCHAR(1024)
- an_date — DATE
- ad_id — VARCHAR(40) — NOT NULL
Calendar
- cal_id — INTEGER — Primary key — NOT NULL
- t_id — INTEGER — Foreign key → Vchat_teacher.t_id — NOT NULL
- cal_date — DATE
- cal_time — VARCHAR(40)
Coding_Board
- co_id — INTEGER — Primary key — NOT NULL
- m_idint — INTEGER — Foreign key → Member.m_idint — NOT NULL
- co_q — VARCHAR(1024)
- co_date — DATE
Coding_Board_Answer
- co_ans_id — INTEGER — Primary key — NOT NULL
- co_id — INTEGER — Foreign key → Coding_Board.co_id — NOT NULL
- m_idint — INTEGER — Foreign key → Member.m_idint — NOT NULL
- co_ans — VARCHAR(1024)
- co_ans_date — DATE
Education
- ed_id — INTEGER — Primary key — NOT NULL
- ed_title — VARCHAR(40)
- ed_name — VARCHAR(50)
- ed_enlist_date — DATE
- ed_start_date — DATE
- ed_end_date — DATE
- ed_addr — VARCHAR(40)
- ed_price — INTEGER
- ed_intro — VARCHAR(1024)
- ed_keyword — VARCHAR(200)
- ed_time — VARCHAR(40)
- ed_comm — VARCHAR(40)
- ed_curriculum — VARCHAR(1024)
- ed_tf — BOOLEAN
- ed_pic — VARCHAR(200)
- ed_days — DATE
Education_Enroll
- b_ed_id — INTEGER — Primary key — NOT NULL
- b_id — VARCHAR(40) — Foreign key → business.b_id — NOT NULL
- ed_id — INTEGER — Foreign key → Education.ed_id — NOT NULL
Honest_Answer
- ha_id — INTEGER — Primary key — NOT NULL
- m_idint — INTEGER — Foreign key → Member.m_idint — NOT NULL
- hq_id — INTEGER — Foreign key → Honest_Question.hq_id — NOT NULL
- ha_a — VARCHAR(1024)
- hq_date — DATETIME
Honest_Question
- hq_id — INTEGER — Primary key — NOT NULL
- m_idint — INTEGER — Foreign key → Member.m_idint — NOT NULL
- hq_title — VARCHAR(100)
- hq_q — VARCHAR(1024)
- hq_date — DATETIME
- hq_keyword — VARCHAR(100)
- hq_category — VARCHAR(50) — NOT NULL
- hq_cnt — INTEGER
Jjim
- jj_id — INTEGER — Primary key — NOT NULL
- m_idint — INTEGER — Foreign key → Member.m_idint — NOT NULL
- vc_id — INTEGER — Foreign key → Vchat_Class.vc_id — NOT NULL
- t_id — INTEGER — Foreign key → Vchat_Class.t_id — NOT NULL
Member
- m_idint — INTEGER — Primary key — NOT NULL
- m_pass — VARCHAR(40)
- m_idstring — VARCHAR(40)
- m_name — VARCHAR(40)
- m_tel — VARCHAR(40)
- m_post — CHAR(5)
- m_addr — VARCHAR(80)
- m_addr_sub — VARCHAR(80)
- m_email — VARCHAR(40)
- m_profile — VARCHAR(50)
- p_end_date — DATE — 아래부터결제
- p_daysperweek — INTEGER(1)
- p_minute — INTEGER(2)
- p_days_left — INTEGER(1)
- t_id — INTEGER — Foreign key → Vchat_teacher.t_id
Member_Kakao (Untitled)
- mk_id — INTEGER — Primary key — NOT NULL
- m_idint — INTEGER — Foreign key → Member.m_idint — NOT NULL
- m_name — VARCHAR(40)
News
- news_id — INTEGER — Primary key — NOT NULL
- news_title — VARCHAR(500)
- news_date — DATE
- news_content — VARCHAR(8000)
- news_img — VARCHAR(300)
- news_man — VARCHAR(30)
- news_short — VARCHAR(1024)
Pay
- p_id — INTEGER — Primary key — NOT NULL
- m_idint — INTEGER — Foreign key → Member.m_idint — NOT NULL
- p_date — DATE
- p_total — INTEGER
- p_info — VARCHAR(100)
- p_return — BOOLEAN
Report
- re_id — INTEGER — Primary key — NOT NULL
- m_idint — INTEGER — Foreign key → Member.m_idint — NOT NULL
- re_m_id — INTEGER — Foreign key → Report_Management.re_m_id — NOT NULL
- re_date — DATE
- re_reason — VARCHAR(200)
- re_content — VARCHAR(1024)
Report_Management
- re_m_id — INTEGER — Primary key — NOT NULL
- re_m_date — DATE
- re_m_result — VARCHAR(50)
- re_m_reason — VARCHAR(500)
Review
- re_id — INTEGER — Primary key — NOT NULL
- m_idint — INTEGER — Foreign key → Member.m_idint — NOT NULL
- re_date — DATE
- star — INTEGER
- re_content — VARCHAR(1024)
- ed_id (ed_id2) — INTEGER — Foreign key → Education.ed_id — NOT NULL
- vc_id (vc_id2) — INTEGER — Foreign key → Vchat_Class.vc_id — NOT NULL
Vchat_Class
- vc_id — INTEGER — Primary key — NOT NULL
- t_id — INTEGER — Foreign key → Vchat_teacher.t_id — NOT NULL
- vc_title — VARCHAR(50)
- vc_intro — VARCHAR(1024)
- vc_content — VARCHAR(1024)
- vc_keyword — VARCHAR(200)
- vc_pic — VARCHAR(30)
Vchat_Record
- vc_rec_id — INTEGER — Primary key — NOT NULL
- m_idint — INTEGER — Foreign key → Member.m_idint — NOT NULL
- vc_id — INTEGER — Foreign key → Vchat_Class.vc_id — NOT NULL
- vc_rec_date — DATE
- vc_rec_time — DATE
Vchat_Reserve
- vr_id — INTEGER — Primary key — NOT NULL
- m_idint — INTEGER — Foreign key → Member.m_idint — NOT NULL
- vc_id — INTEGER — Foreign key → Vchat_Class.vc_id — NOT NULL
- t_id — INTEGER — Foreign key → Vchat_Class.t_id — NOT NULL
- vr_date — DATE
- vr_time — VARCHAR(40)
Vchat_teacher
- t_id — INTEGER — Primary key — NOT NULL
- t_pic — VARCHAR(30)
- t_name — VARCHAR(30)
- t_intro — VARCHAR(1024)
- t_spec — VARCHAR(1024)
Wishlist
- w_id — INTEGER — Primary key — NOT NULL
- m_idint — INTEGER — Foreign key → Member.m_idint — NOT NULL
- ed_id — INTEGER — Foreign key → Education.ed_id — NOT NULL
business
- b_id — VARCHAR(40) — Primary key — NOT NULL
- b_pass — VARCHAR(40)
- b_tel — INTEGER
- b_email — VARCHAR(40)
- b_ed_name — VARCHAR(40)