Claon
Tables (50)
banners
- id — int — Primary key — NOT NULL
- created_date — timestamp — NOT NULL — 생성 시간
- data_type — varchar(255) — NOT NULL — 데이터 타입
- description — text — 배너 설명
- end_time — datetime(6) — 마감 날짜
- end_time_display — datetime(6) — 종료 시간 표시
- imageapp — varchar(255) — NOT NULL — 모바일 이미지 주소
- imagepc — varchar(255) — NOT NULL — PC 이미지 주소
- is_display — bit(1) — 노출 여부
- is_use — bit(1) — 사용 여부
- order_number — int — NOT NULL — 주문 번호
- position — int — 위치
- reasons_for_refusal — varchar(255)
- start_time — datetime(6)
- start_time_display — datetime(6)
- status — varchar(255) — NOT NULL
- status_of_aproved — int
- title — varchar(255) — NOT NULL
- type — varchar(255) — NOT NULL
- update_date — timestamp
- value_on_type — varchar(255)
- store_id — smallint — Foreign key → store.store_id — NOT NULL
basket
- id — varchar(36) — Primary key — NOT NULL
- effective_date — datetime(6) — NOT NULL — 유효 날짜
- expiration_date — datetime(6) — NOT NULL — 만료 날짜
- name — varchar(255) — NOT NULL — 이름
- rate — int — NOT NULL — 별점
category
- id — int — Primary key — NOT NULL
- create_date — datetime(6)
- image — varchar(255)
- name — varchar(255) — NOT NULL
- parent_id — int — Foreign key → category.id
category_part_teacher
- id — int — Primary key — NOT NULL
- order_number — int — NOT NULL
- subject — varchar(255)
- category_id — int
- detailed_field_id — int
- teacher_id — smallint
- user_id — varchar(36)
contracts
- id — smallint — Primary key — NOT NULL
- settlement_clause — text
- contract_date — datetime(6)
- end_date — datetime(6)
- json_subject_id — varchar(255)
- start_date — datetime(6)
- tax — decimal(12,4) — NOT NULL
- taxable_type — int
- type — int
- store_id — smallint — Foreign key → store.store_id
coupon
- id — varchar(36) — Primary key — NOT NULL
- effective_date — datetime(6) — NOT NULL
- expiration_date — datetime(6) — NOT NULL
- name — varchar(255) — NOT NULL
- rate — int — NOT NULL
customer_entity
- entity_id — int — Primary key — NOT NULL
- category_grade — int — NOT NULL
- coin — int — NOT NULL
- created_at — datetime(6)
- email — varchar(50) — NOT NULL
- game_exp — int — NOT NULL
- heart_cnt — int — NOT NULL
- login_id — varchar(50) — NOT NULL
- main_category — int — NOT NULL
- password — varchar(255) — NOT NULL
- profile_img — varchar(255) — NOT NULL
- sub_category — int — NOT NULL
- user_id — varchar(255) — NOT NULL
customer_group
- customer_group_id — int — Primary key — NOT NULL
- created_at — datetime(6)
- group_category — int — NOT NULL
- name — varchar(255)
- profile_img — varchar(255)
- store_id — int — NOT NULL
- thumbnail_url — varchar(255)
detailed_field
- id — int — Primary key — NOT NULL
- create_date — timestamp — NOT NULL
- name — varchar(255) — NOT NULL
- category_id — int — Foreign key → category.id
- image — varchar(255)
event
- id — bigint — Primary key — NOT NULL
- category_id — int
- description — mediumtext
- detailed_field_id — int
- end_date — datetime(6)
- image_app — varchar(255)
- image_pc — varchar(255)
- rank_id — int
- start_date — datetime(6)
- title — varchar(255)
- is_use — bit(1)
- expose — bit(1)
- description_notify — varchar(255)
- title_notify — varchar(255)
faq
- id — bigint — Primary key — NOT NULL
- attachment_url — varchar(255) — NOT NULL
- content — text — NOT NULL
- create_at — datetime(6)
- is_use — bit(1) — NOT NULL
- status — varchar(255)
- title — varchar(255)
- type — varchar(255)
- type_faq — varchar(255)
- faq_id — bigint — Foreign key → faq.id
first_detail
- id — bigint — Primary key — NOT NULL
- code — varchar(255)
- kind — varchar(255)
- level — int — NOT NULL
- man_name — varchar(255)
- man_pic — varchar(255)
- remark — varchar(255)
- telno — varchar(255)
- telno2 — varchar(255)
- time — bigint — NOT NULL
- time_string — varchar(255)
- where_string — varchar(255)
gift
- id — int — Primary key — NOT NULL
- create_at — datetime(6)
- is_available — bit(1) — NOT NULL
- name — varchar(255) — NOT NULL
- ordinal_number — bigint — NOT NULL
- type — varchar(255)
graded
- id — int — Primary key — NOT NULL
- create_date — datetime(6)
- name — varchar(255)
group_purchase
- id — bigint — Primary key — NOT NULL
- create_date — datetime(6)
- total_price — decimal(19,2)
- group_registration_id — varchar(36) — Foreign key → group_registration.id — NOT NULL
group_registration
- id — varchar(36) — Primary key — NOT NULL
- adress — varchar(255)
- authority — int — NOT NULL
- detail_adress — varchar(255)
- id_user — binary(255)
- image — varchar(255)
- number_id — varchar(255)
- organization_name — varchar(255)
- password — varchar(255)
- zip_code — varchar(255)
hibernate_sequence
- next_val — bigint
hibernate_sequences
- sequence_name — varchar(255) — Primary key — NOT NULL
- next_val — bigint
history_call_wrong_ox_quiz
- id — bigint — Primary key — NOT NULL
- create_at — datetime(6)
- user_id — varchar(255)
history_login
- id — bigint — Primary key — NOT NULL
- access_time — datetime(6)
- browser — varchar(255)
- email — varchar(255)
- ip — varchar(255)
- is_success — bit(1) — NOT NULL
- login_by — varchar(255)
- name — varchar(255)
- operating_system — varchar(255)
inquiries
- id — bigint — Primary key — NOT NULL
- content — varchar(255)
- create_date — datetime(6)
- status — varchar(255)
- title — varchar(255)
- type — varchar(255) — NOT NULL
- group_registration_id — varchar(36) — Foreign key → group_registration.id
- store_id — smallint — Foreign key → store.store_id
inquiries_image
- id — int — Primary key — NOT NULL
- url — varchar(255)
- inquiries_id — bigint — Foreign key → inquiries.id — NOT NULL
last_detail
- id — int — Primary key — NOT NULL
- code — varchar(255)
- kind — varchar(255)
- level — int — NOT NULL
- man_name — varchar(255)
- man_pic — varchar(255)
- remark — varchar(255)
- telno — varchar(255)
- telno2 — varchar(255)
- time — bigint — NOT NULL
- time_string — varchar(255)
- where_string — varchar(255)
last_state_detail
- id — bigint — Primary key — NOT NULL
- code — varchar(255)
- kind — varchar(255)
- level — int — NOT NULL
- man_name — varchar(255)
- man_pic — varchar(255)
- remark — varchar(255)
- telno — varchar(255)
- telno2 — varchar(255)
- time — bigint — NOT NULL
- time_string — varchar(255)
- where_string — varchar(255)
lecture_offline
- id — bigint — Primary key — NOT NULL
- address — varchar(255)
- days_of_week — varchar(255)
- detailed_address — varchar(255)
- end_date — datetime(6)
- lat_lng — varchar(255)
- number_of_lectures — int
- number_of_students — int
- start_date — datetime(6)
- zip_code — int
lectures_free
- id — bigint — Primary key — NOT NULL
- notice_image — varchar(255)
- thumbnail_image — varchar(255)
- title — varchar(255)
lectures_live
- id — bigint — Primary key — NOT NULL
- broadcasts_key — varchar(255)
- channel_id — bigint
- channel_key — varchar(255)
- class_start_date — datetime(6)
- cumulative_viewer_count — int
- is_onair — bit(1)
- live_count — int
- live_thumbnail_image — varchar(255)
- live_thumbnail_image_mobile — varchar(255)
- maximum_concurrent_viewer — varchar(255)
- notice_image — varchar(255)
lectures_package
- id — bigint — Primary key — NOT NULL
- close_enrollment_date — datetime(6)
- code — varchar(255)
- days_of_week — varchar(255)
- end_date — datetime(6)
- notice_image — varchar(255)
- number_of_lectures — int
- number_of_students — int
- period_type — int
- start_date — datetime(6)
level_setting
- id — int — Primary key — NOT NULL
- level — int — NOT NULL
- point — int — NOT NULL
list_user_in_group
- id — int — Primary key — NOT NULL
- id_group — int
- id_user — binary(255)
notice
- id — bigint — Primary key — NOT NULL
- content — varchar(255)
- create_date — timestamp — NOT NULL
- is_pin — bit(1)
- is_use — bit(1)
- store_id — smallint
- stt — int — NOT NULL
- title — varchar(255)
notice_admin
- id — bigint — Primary key — NOT NULL
- content — varchar(255)
- create_date — timestamp — NOT NULL
- file — varchar(255)
- is_pin — bit(1)
- stt — int — NOT NULL
- title — varchar(255)
- type_notice_admin — int
- is_use — bit(1)
- user_id — varchar(255)
notice_teacher
- id — bigint — Primary key — NOT NULL
- content — varchar(255)
- create_date — timestamp — NOT NULL
- stt — int — NOT NULL
- teacher_id — smallint
- is_use — bit(1)
order_data
- id — bigint — Primary key — NOT NULL
- message — varchar(255)
- order_number — varchar(255)
- price — int — NOT NULL
- purchase_id — varchar(255)
- signature — varchar(255)
- timestamp — bigint — NOT NULL
pickup
- id — bigint — Primary key — NOT NULL
- bill_lading_code — varchar(255)
- code_shipping — varchar(255)
- create_date — datetime(6)
- status — varchar(255)
popup_category
- popup_id — bigint — Foreign key → popups.id — NOT NULL
- category_id — int — Foreign key → category.id — NOT NULL
popups
- id — bigint — Primary key — NOT NULL
- content — varchar(255) — NOT NULL
- create_at — datetime(6)
- data_type — int — NOT NULL
- end_date — datetime(6) — NOT NULL
- end_time — varchar(255) — NOT NULL
- form_type — varchar(255) — NOT NULL
- is_availability — bit(1) — NOT NULL
- is_displayed_period — bit(1) — NOT NULL
- start_date — datetime(6) — NOT NULL
- start_time — varchar(255) — NOT NULL
- title — varchar(255) — NOT NULL
- value_on_type — text — NOT NULL
purchase_cancel
- id — bigint — Primary key — NOT NULL
- create_date — datetime(6)
- message — varchar(255)
- note — varchar(255)
- purchase_id — varchar(36)
- reason — varchar(255)
- status — varchar(255)
- store_id — smallint
- update_date — datetime(6)
- user_id — varchar(36)
purchase_exchange
- id — bigint — Primary key — NOT NULL
- bill_lading_code — varchar(255)
- code_shipping — varchar(255)
- create_date — datetime(6)
- note — varchar(255)
- reason — varchar(255)
- update_date — datetime(6)
- pickup_id — bigint — Foreign key → pickup.id
purchase_refund
- id — bigint — Primary key — NOT NULL
- create_date — datetime(6)
- reason — varchar(255)
- refund_amount — decimal(19,2)
- purchase_refund_detail_id — bigint — Foreign key → purchase_refund_detail.id
purchase_refund_detail
- id — bigint — Primary key — NOT NULL
- account_holder — varchar(255)
- bank_account — varchar(255)
- bank_name — varchar(255)
- case_refund — varchar(255)
- message — varchar(255)
- status — varchar(255)
- total_refund — decimal(19,2)
- user_id — varchar(36)
purchase_return
- id — bigint — Primary key — NOT NULL
- bill_lading_code — varchar(255)
- code_shipping — varchar(255)
- create_date — datetime(6)
- is_return — bit(1)
- note — varchar(255)
- reason — varchar(255)
- status — varchar(255)
- update_date — datetime(6)
- pickup_id — bigint — Foreign key → pickup.id
purchase_return_product_book
- product_book_order — int — Primary key — NOT NULL
- purchase_return_id — bigint — Foreign key → purchase_return.id — NOT NULL
- product_book — bigint
ranking
- id — bigint — Primary key — NOT NULL
- score_category — bigint
- score_detail — bigint
- score_lecturer — bigint
- score_rating — bigint
- score_subject — bigint
- standard_ranking — varchar(255) — NOT NULL
- user_id — varchar(36) — NOT NULL
search
- id — bigint — Primary key — NOT NULL
- count — bigint — NOT NULL
- text — varchar(255)
store
- store_id — smallint — Primary key — NOT NULL
- account_holder — varchar(255)
- account_number — varchar(255)
- authority — int
- bank_book_copy — varchar(255)
- bank_name — varchar(255)
- banner — varchar(255)
- business_lic_path — varchar(255)
- business_number — varchar(255)
- business_registration — varchar(255)
- code — varchar(255)
- contact_name — varchar(255)
- contact_number — varchar(255)
- created_at — datetime(6) — NOT NULL
- email — varchar(255) — NOT NULL
- introduction — text
- is_admin_store — bit(1) — NOT NULL
- is_first_login — bit(1)
- is_notify — bit(1)
- name — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- phone — varchar(255) — NOT NULL
- profile_avatar — varchar(255)
- status — varchar(255) — NOT NULL
- updated_at — datetime(6)
student_types
- id — smallint — Primary key — NOT NULL
- value — varchar(255)
temp_video_data
- temp_id — bigint — Primary key — NOT NULL
- code — varchar(255)
- duration — int
- is_trial_available — bit(1)
- multiplier — decimal(19,2)
- lecture_depth — int
- title — varchar(255)
- video_file_name — varchar(255)
- video_fileurl — varchar(255)
- lectures_id — varchar(36)
- media_key — varchar(36)
- work_date — varchar(8)
template
- id — int — Primary key — NOT NULL
- content — varchar(255) — NOT NULL
- json_button_list — varchar(255) — NOT NULL
- registrant — varchar(255) — NOT NULL
- state — varchar(255)
- template_code — varchar(255) — NOT NULL
- template_name — varchar(255) — NOT NULL
users_group
- id — varchar(36) — Primary key — NOT NULL
- course_period — varchar(255)
- cumulative — varchar(255)
- month_attendance — varchar(255)
- progress_rate — varchar(255)
- remaining_days — datetime(6)
- student_avatar — varchar(255)
- student_name — varchar(255)
- taking_device — varchar(255)