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