MAS9

Tables (81)

Address_change_requests

  • id — Primary key — NOT NULL
  • order_id — integer — Foreign key → Orders.id — NOT NULL
  • new_address — varchar(100)
  • reason — varchar(100)

Advice_request

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → Users.id — NOT NULL
  • time — datetime
  • method — varchar(20)
  • address — varchar(50)
  • status — varchar(20)
  • school_id — integer

Advices

  • id — integer — Primary key — NOT NULL
  • createdBy — integer — Foreign key → FRadmins.id — NOT NULL
  • title — varchar(50)
  • detail — varchar(200)
  • method — varchar(20) — 구분
  • createdAt — timestamp
  • updatedAt — timestamp
  • updatedBy — integer

App_config

  • id — integer — Primary key — NOT NULL
  • home_page_url — varchar(50)
  • introduce_data — varchar(300)
  • main_image_1_path — varchar(100)
  • main_image_2_path — varchar(100)
  • main_image_3_path — varchar(100)
  • show_shool_image — boolean
  • show_progam — boolean
  • show_member — boolean
  • show_ecommerce — boolean
  • program_1_id — integer
  • program_2_id — integer
  • program_3_id — integer
  • updatedAt — timestamp
  • updatedBy — integer
  • language — varchar(10)

Attached_file_daily_nofication

  • id — integer — Primary key — NOT NULL
  • daily_notification — integer — Foreign key → Daily_notifications.id — NOT NULL
  • file_path — varchar(100)
  • file_type — varchar(10)
  • preview — boolean

Attendance

  • id — integer — Primary key — NOT NULL
  • student_id — integer — Foreign key → Users.id — NOT NULL
  • schedule_id — integer — Foreign key → Schedules.id — NOT NULL
  • status — varchar(20)
  • class_id — integer — Foreign key → Classes.id — NOT NULL
  • attendance_datetime — timestamp

Banners

  • id — integer — Primary key — NOT NULL
  • created_by — integer
  • created_at — timestamp
  • updated_at — timestamp
  • updated_by — integer
  • name — varchar(50)
  • start_datetime — timestamp
  • end_datetime — timestamp
  • is_active — boolean
  • link — varchar(100)
  • file_path — varchar(100)
  • exposure_order — varchar(20)
  • classify — varchar(30)
  • exposure_position — varchar(20)

Cancellation_requests

  • id — Primary key — NOT NULL
  • order_id — integer — Foreign key → Orders.id — NOT NULL
  • status — varchar(20)
  • reason — varchar(100)

Cancle_member_request

  • id — integer — Primary key — NOT NULL
  • member_id — integer — Foreign key → Users.id — NOT NULL
  • reason — varchar(200)
  • status — varchar(20)
  • updated_by — integer — FR and PL
  • updated_at — timestamp
  • handle_by — integer
  • created_at

Cart

  • id — integer — Primary key — NOT NULL
  • customer_id — integer — Foreign key → Users.id — NOT NULL

Cart_items

  • id — integer — Primary key — NOT NULL
  • cart_id — integer — Foreign key → Cart.id — NOT NULL
  • product_id — integer — Foreign key → Products.id — NOT NULL
  • quantity — int

Certificates

  • id — integer — Primary key — NOT NULL
  • school_id — integer — Foreign key → Schools.id — NOT NULL
  • student_id — integer
  • event_id — integer
  • created_by — integer
  • created_at — timestamp
  • updated_at — timestamp
  • updated_by — integer
  • is_active — boolean
  • background_path — varchar(100)
  • providing_datetime — timestamp

Class_registrations

  • id — integer — Primary key — NOT NULL
  • class_id — integer — Foreign key → Classes.id — NOT NULL
  • student_id — integer — Foreign key → Users.id — NOT NULL
  • created_by — integer
  • created_at — timestamp
  • updated_at — timestamp
  • updated_by — integer
  • status — varchar(20)
  • registration_date — timestamp
  • target — varchar(20)
  • is_active — boolean
  • Field2 — 제목
  • Field — 조회

Classes

  • id — integer — Primary key — NOT NULL
  • lecturer_id — integer — Foreign key → FRadmins.id — NOT NULL
  • program_id — integer — Foreign key → Programs.id — NOT NULL
  • name — varchar(50)
  • start_date — date
  • end_date — date
  • limit — int
  • describle — varchar(100)
  • created_by — integer
  • created_at — timestamp
  • updated_by — integer
  • updated_at — timestamp
  • star_time — time
  • lecturer_name — varchar(50)
  • class_color — varchar(10)

Comments

  • id — integer — Primary key — NOT NULL
  • content — varchar(200)
  • user_id — integer
  • rate — decimal
  • picture_id — integer

Daily_notifications

  • id — integer — Primary key — NOT NULL
  • title — varchar(100)
  • detail — varchar(300)
  • updated_by — integer
  • created_by — integer — Fr_id
  • updated_at — timestamp
  • created_at — timestamp
  • target — varchar(10)

Diary

  • id — integer — Primary key — NOT NULL
  • student_id — integer — Foreign key → Users.id — NOT NULL
  • title — varchar(100)
  • content — varchar
  • created_at — timestamp
  • updated_at — timestamp
  • emotion — int

Diary_image

  • id — integer — Primary key — NOT NULL
  • diary_id — integer — Foreign key → Diary.id — NOT NULL
  • image_path — varchar(100)
  • favourite — boolean

Documents

  • id — integer — Primary key — NOT NULL
  • student_id — integer — Foreign key → Users.id — NOT NULL
  • title — varchar(50)
  • created_at — timestamp
  • updated_at — timestamp
  • updated_by — integer
  • attached _file_type — varchar(20)
  • attached _file_path — varchar(100)
  • created_by

Downloads

  • id — integer — Primary key — NOT NULL
  • android_number — int
  • ios_number — int

E_Learning

  • id — integer — Primary key — NOT NULL
  • title — varchar(100)
  • created_at — timestamp
  • updated_at — timestamp
  • updated_by — integer
  • is_active — boolean
  • is_public — boolean
  • text_content — varchar
  • target_id — integer — all or group
  • created_by — integer
  • target_type — varchar(20)

E_Learning_files

  • id — integer — Primary key — NOT NULL
  • E_Learning_id — integer — Foreign key → E_Learning.id — NOT NULL
  • file_type — varchar(20)
  • file_path — varchar(100)

Evaluation

  • id — integer — Primary key — NOT NULL
  • student_id — integer — Foreign key → Users.id — NOT NULL
  • is_active — boolean
  • detail — varchar(500)
  • signature — varchar(100)
  • updated_at — timestamp
  • updated_by — integer
  • created_at — timestamp
  • created_by — integer

Event_registrations

  • id — integer — Primary key — NOT NULL
  • event_id — integer — Foreign key → Events.id — NOT NULL
  • student_id — integer — Foreign key → Users.id — NOT NULL
  • registration_date — timestamp

Events

  • id — integer — Primary key — NOT NULL
  • updated_by — integer
  • situation — varchar(20) — 상태
  • name — varchar(50)
  • classify — varchar(30)
  • price — decimal
  • main_image_url — varchar(100)
  • detail_image_url — varchar(100)
  • registration_start_time — timestamp
  • registration_end_time — timestamp
  • summary_description — varchar(200)
  • target — integer — FR/user or group
  • updated_at — timestamp
  • created_at — timestamp
  • created_by — integer

Exchange_products

  • product_id — integer — Foreign key → Products.id — NOT NULL
  • exchange_request_id — Foreign key → Exchange_requests.id — NOT NULL
  • quantity — int

Exchange_requests

  • id — Primary key — NOT NULL
  • order_id — integer — Foreign key → Orders.id — NOT NULL
  • status — varchar(20)
  • reason — varchar(100)

FAQ_attached_file

  • faq_id — integer — Foreign key → FAQs.id — NOT NULL
  • file_type — varchar(20)
  • file_path — varhcar(100)

FAQs

  • id — integer — Primary key — NOT NULL
  • assignment — varchar(30)
  • title — varchar(100)
  • detail — varchar(500)
  • target_type — varchar(20) — all or group
  • target_jd — integer

FR_notes

  • id — integer — Primary key — NOT NULL
  • fr_id — integer — Foreign key → FRadmins.id — NOT NULL
  • note — varchar(300)

FR_registration_requests

  • id — integer — Primary key — NOT NULL
  • fr_register_id — integer — Foreign key → FRadmins.id — NOT NULL
  • handle_at — timestamp
  • approval_status — varchar(20)
  • approval_date — timestamp
  • rejection_reason — varchar(100)
  • registration_date — timestamp
  • handle_by — integer

FRadmins

  • id — integer — Primary key — NOT NULL
  • fullname — varchar(50)
  • email — varchar(50)
  • created_at — timestamp
  • updated_at — timestamp
  • updated_by — integer
  • created_by — integer
  • approved — boolean
  • password — varchar(50) — encode
  • representative_number — varchar(30) — 대표번호
  • seal_number — varchar(30) — 도장번호
  • date_of_birth — date
  • seal_name — varchar(50) — 도장명
  • stamp_logo_path — varchar(200) — 도장로고
  • stamped_address_1 — varchar(100) — 도장주소
  • stamped_address_2 — varchar(100)
  • city — varchar(20)
  • nation — varchar(20)
  • state — varchar(20)
  • zip_code — varchar(20)
  • company_registration_number — varchar(20) — 사업자등록번호
  • seal_description — varchar(300) — 도장설명
  • video_link — varchar(200) — 동영상링크
  • status — varcha(50)
  • is_active — boolean

Favorite_management

  • id — integer — Primary key — NOT NULL
  • fr_id — integer — fr, pl
  • favorite_features — boolean

Favorite_product

  • id — integer — Primary key — NOT NULL
  • product_id — integer — Foreign key → Products.id — NOT NULL
  • customer_id — integer — Foreign key → Users.id — NOT NULL

Groups

  • id — integer — Primary key — NOT NULL
  • name — varchar(50)
  • detail — varchar(200)
  • limit — int
  • updated_at — timestamp
  • created_at — timestamp
  • updated_by — integer
  • created_by — integer — FR_id

Guardian

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → Users.id — NOT NULL
  • fullname — varchar(50)
  • relationship — varchar(10)
  • phone_number — varchar(10)
  • email — varchar(50)

Homework_tasks

  • id — integer — Primary key — NOT NULL
  • homewwork_id — integer — Foreign key → Homeworks.id — NOT NULL
  • detail — varchar(500)

Homeworks

  • id — integer — Primary key — NOT NULL
  • name — varchar(30)
  • start_submit_time — timestamp
  • end_submit_time — timestamp
  • lecturer_name — varchar(50)
  • updated_by — integer
  • created_by — integer
  • created_at — timestamp — Fr_id
  • updated_at — timestamp
  • class_time — time
  • target — integer — all or group
  • status — varchar(20)

Image_product

  • id — integer — Primary key — NOT NULL
  • product_id — integer — Foreign key → Products.id — NOT NULL
  • image_path — varchar(100)
  • is_active — boolean
  • is_main — boolean

Leave_requests

  • id — integer — Primary key — NOT NULL
  • student_id — integer — Foreign key → Users.id — NOT NULL
  • schedule_id — integer — Foreign key → Schedules.id — NOT NULL
  • date_of_request — timestamp
  • reason — varchar(50)
  • status — varchar(20)

Login_history

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → Users.id — NOT NULL
  • login_datetime — timestamp
  • ip_address — varchar(30)
  • info — varchar(50)
  • note — varchar(200)

Mail_attached_file

  • mail_id — integer — Foreign key → Mails.id — NOT NULL
  • file_type — varchar(20)
  • file_path — varhcar(100)

Mail_template

  • id — integer — Primary key — NOT NULL
  • name — varchar(50)
  • is_active — boolean
  • image_type — varchar(20)
  • image_path — varchar(100)
  • is_advance_preparation — boolean
  • intend_time — timestamp
  • is_repetition — boolean
  • contain — varchar(300)
  • created_by — integer
  • created_at — timestamp
  • updated_at — timestamp
  • updated_by — timestamp

Mails

  • id — integer — Primary key — NOT NULL
  • receiver — varchar
  • title — varchar(200)
  • content — varchar(500)
  • created_by — integer
  • created_at — timestamp
  • email_sending_time — timestamp
  • is_repetition — boolean
  • is_advance_preparation — boolean
  • intend_time — timestamp
  • status — varchar(30)
  • receiver_ip — varchar(30)

Membership_types

  • id — integer — Primary key — NOT NULL
  • name — varchar(20)
  • decription — varchar(100)
  • price — decimal
  • features — varchar(100) — bundled features

Messages

  • id — integer — Primary key — NOT NULL
  • room_id — integer — Foreign key → Rooms.id — NOT NULL — Socket.io technology
  • message_text — varchar
  • file_type — integer — Attachment type
  • file_url — varchar(50)
  • sent_datetime — timestamp
  • sender_role — varchar(20)
  • sender_id — interger

Notification

  • id — integer — Primary key — NOT NULL
  • title — varchar(100)
  • detail — varchar(200)
  • link — varchar(100)
  • is_repetition — boolean
  • is_advance_preparation — boolean
  • intend_time — timestamp
  • notification_sending_time — timestamp
  • created_at — timestamp
  • created_by — integer
  • target_type — varchar(20) — all or group
  • target_id — integer

Option_information

  • id — integer — Primary key — NOT NULL
  • event_id — integer — Foreign key → Events.id — NOT NULL
  • option_name — varchar(50) — 옵션명
  • property — varchar(50) — 속성
  • input_method — varchar(50) — 입력방식

Order_items

  • id — integer — Primary key — NOT NULL
  • order_id — integer — Foreign key → Orders.id — NOT NULL
  • product_id — integer — Foreign key → Products.id — NOT NULL
  • price — decimal
  • quantity — int

Orders

  • id — integer — Primary key — NOT NULL
  • customer_id — integer — Foreign key → Users.id — NOT NULL
  • status — varchar(50)
  • order_date — timestamp
  • total_amount — decimal
  • discount_code — varchar(50)
  • created_at — timestamp
  • updated_at — timestamp
  • created_by — integer
  • updated_by — integer
  • ship_datetime — timestamp

PLadmins

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • updated_by — integer
  • created_by — integer
  • fullname — varchar(50)
  • email — varchar(50)
  • password — varchar(50) — encode
  • is_active — boolean

Participants

  • id — integer — Primary key — NOT NULL
  • room_id — integer — Foreign key → Rooms.id — NOT NULL — Socket.io technology

Payment

  • id — integer — Primary key — NOT NULL
  • payment_type — varchar(50)
  • payment_info — varchar(100) — encoded
  • is_active — boolean
  • customer_role — varchar(20)
  • customer_id — integer

Payment_transactions

  • id — integer — Primary key — NOT NULL
  • payment_id — integer — Foreign key → Payment.id — NOT NULL
  • payment_amount — decimal
  • payment_date — timestamp
  • status — varchar(50)
  • paid_amount — decimal
  • remaining_amount — decimal
  • receipt_path — varchar(50)
  • note — varchar(100)
  • service_classification — varchar(20) — ENUM('event", ...)
  • service_id — interger — order_id, event_registrations_id, program_id

Popups

  • id — integer — Primary key — NOT NULL
  • created_by — integer
  • created_at — timestamp
  • updated_at — timestamp
  • updated_by — integer
  • name — varchar(50)
  • start_datetime — timestamp
  • end_datetime — timestamp
  • isActive — boolean
  • file_type — varchar(20)
  • link — varchar(100)
  • file_path — varchar(100)
  • classify — varchar(30)
  • popup_size — varchar(20)
  • popup_position — varchar(20)

Product_variants

  • id — integer — Primary key — NOT NULL
  • product_id — integer — Foreign key → Products.id — NOT NULL
  • color — varchar(20)
  • quantity — int
  • size — decimal
  • is_hiding — boolean
  • property — varchar(20)

Products

  • id — integer — Primary key — NOT NULL
  • name — varchar(50)
  • SKU — varchar(20)
  • is_active — boolean
  • created_at — timestamp
  • updated_at — timestamp
  • created_by — integer — FR_admin
  • updated_by — integer
  • regular_price — decimal
  • tax — decimal
  • status — varchar(50)
  • classify — varchar(20) — enum (new, popular, all)
  • logo_path — varchar(100)
  • sumary_info — varchar(300)

Program_registrations

  • id — integer — Primary key — NOT NULL
  • program_id — integer — Foreign key → Programs.id — NOT NULL
  • student_id — integer — Foreign key → Users.id — NOT NULL
  • registration_date — timestamp
  • activation_date — timestamp
  • is_active — boolean
  • expiration date — timestamp
  • value — integer
  • status — varchar(20)
  • duration — integer

Programs

  • id — integer — Primary key — NOT NULL
  • school_id — integer — Foreign key → Schools.id — NOT NULL
  • program_name — varchar(50)
  • describe — varchar(100)
  • price — interger
  • image — varchar
  • preview — varchar
  • is_active — boolean
  • created_at — timestamp
  • updated_at — timestamp
  • created_by — integer
  • updated_by — integer

Promotion_histories

  • id — integer — Primary key — NOT NULL
  • event_id — integer — Foreign key → Events.id — NOT NULL
  • student_id — integer
  • resutl — varchar(20)
  • rank — varchar(20)

Rank

  • id — integer — Primary key — NOT NULL
  • progam_id — integer — Foreign key → Programs.id — NOT NULL
  • name — varchar(50)
  • set_top_color — varchar(10)
  • bottom_color_setting — varchar(10)
  • center_stripe_settings — varchar(20)
  • stripe_color_settings — varchar(10)
  • set_the_number_of_tips — int — 팁 개수 설정
  • set_tip_color — varchar(10) — 팁 색상 설정
  • required_date — int
  • required_tasks — varchar(50)
  • required_class — int
  • color_preview — varchar(10)
  • note — varchar(200)
  • is_active — boolean
  • is_apply — boolean
  • created_by — integer
  • created_at — timestamp

Return_requests

  • id — Primary key — NOT NULL
  • order_id — integer — Foreign key → Orders.id — NOT NULL
  • status — varchar(20)
  • reason — varchar(100)

Rooms

  • id — integer — Primary key — NOT NULL — Socket.io technology
  • room_name — varchar(30)

SMS

  • id — integer — Primary key — NOT NULL
  • title — varchar(100)
  • detail — varchar(200)
  • quantity — int
  • is_repetition — boolean
  • is_advance_preparation — boolean
  • intend_time — timestamp
  • sms_sending_time — timestamp
  • created_at — timestamp
  • created_by — integer
  • reciever_id — integer — all or group
  • reciever_type — varchar(30)

SMS_template

  • id — integer — Primary key — NOT NULL
  • name — varchar(50)
  • is_active — boolean
  • image_type — varchar(20)
  • image_path — varchar(100)
  • is_advance_preparation — boolean
  • intend_time — timestamp
  • is_repetition — boolean
  • contain — varchar(300)
  • created_at — timestamp
  • created_by — integer

Scheduled_emails

  • frequency (cycle) — varchar(30)
  • last_sent — timestamp
  • next_sent — timestamp
  • mail_id — integer — Foreign key → Mails.id — NOT NULL

Scheduled_mail_template

  • mail_template_id — integer — Foreign key → Mail_template.id — NOT NULL
  • frequency — varchar(30)
  • next_sent — timestamp

Scheduled_notifications

  • frequency — varchar(30)
  • last_sent — timestamp
  • next_sent — timestamp
  • notification_id — integer — Foreign key → Notification.id — NOT NULL

Scheduled_sms

  • sms_id — integer — Foreign key → SMS.id — NOT NULL
  • frequency — varchar(30)
  • last_sent — timestamp
  • next_sent — timestamp

Scheduled_sms_template

  • frequency — varchar(30)
  • sms_template_id — integer — Foreign key → SMS_template.id — NOT NULL

Schedules

  • id — integer — Primary key — NOT NULL
  • class_id — integer — Foreign key → Classes.id — NOT NULL
  • date — timestamp
  • start_time — timestamp
  • end_time — timestamp
  • status — varchar(20)
  • created_at — timestamp
  • updated_at — timestamp
  • created_by — integer
  • updated_by (update_by) — integer

Schools

  • id — integer — Primary key — NOT NULL
  • created_by
  • created_at — timestamp
  • updated_at — timestamp
  • updated_by — integer
  • school_name — integer
  • phone_number — varchar(15)
  • registration_number — varchar(20)
  • home_page — varchar(30)
  • logo_path — varchar(100)
  • address_1 — varchar(100)
  • address_2 — varchar(100)
  • city — varchar(20)
  • nation — varchar(20)
  • state — varchar(20)
  • facebook — varchar(50)
  • instagram — varchar(50)
  • twitter — varchar(50)

Score_evaluation

  • id — integer — Primary key — NOT NULL
  • evaluation_id — integer — Foreign key → Evaluation.id — NOT NULL
  • score — varchar(1)
  • detail — varchar(100)

Seal_images

  • id — integer — Primary key — NOT NULL
  • fr_admin_id — integer — Foreign key → FRadmins.id — NOT NULL
  • image_path — varchar(50)

Shipment

  • id — integer — Primary key — NOT NULL
  • order_id — integer — Foreign key → Orders.id — NOT NULL
  • customer_id — integer — Foreign key → Orders.customer_id — NOT NULL
  • receiver_name — varchar(50)
  • receiver_phone_number — varchar(50)
  • method — varchar(100)
  • address_1 — varchar(100)
  • address_2 — varchar(100)
  • city — varchar(50)
  • nation — varchar(20)
  • zip_code — varchar(50)
  • status — varchar(20)
  • delivery_options — varchar(50)
  • tracking_number — varchar(20)
  • shipping_information — varchar(30)

Social_media

  • id — integer — Primary key — NOT NULL
  • fr_admin_id — integer — Foreign key → FRadmins.id — NOT NULL
  • facebook — varchar(50)
  • instagram — varchar(50)
  • twitter — varchar(50)

Submit_homeworks

  • id — integer — Primary key — NOT NULL
  • student_id — integer — Foreign key → Users.id — NOT NULL
  • homework_id — integer — Foreign key → Homeworks.id — NOT NULL
  • submit_file_type — varchar(20)
  • submit_file_path — varchar(100)
  • text_content — varchar
  • updated_by — integer
  • updated_at — timestamp
  • created_at — timestamp
  • created_by — integer
  • remark — varchar(200)
  • submit_time — timestamp

User_group

  • group_id — integer — Foreign key → Groups.id — NOT NULL
  • user_id — integer — Foreign key → Users.id — NOT NULL

User_menbership

  • fr_admin_id — integer — Foreign key → FRadmins.id — NOT NULL
  • membership_type_id — integer — Foreign key → Membership_types.id — NOT NULL

Users

  • id — integer — Primary key — NOT NULL
  • fullname — varchar(50) — NOT NULL
  • email — varchar(50) — NOT NULL
  • password — varchar(50) — NOT NULL
  • phone_number — varchar(10)
  • sex — int — 1-3
  • image — varchar(50)
  • health_issues — varchar(50)
  • confirm — boolean
  • isActive — boolean
  • address_1 — varchar(100)
  • address_2 — varchar(100)
  • city — varchar(20)
  • nation — varchar(20)
  • state — varchar(20)
  • zip_code — varchar(20)
  • date_of_birth — date
  • rank — varchar(10)
  • createBy — integer
  • createdAt — timestamp
  • updatedAt — timestamp
  • updatedBy — integer

and 1 more table