Arkademi Team for Company
Version
Version: 1.0
Overview
This document explains the functions of each table in the dataschema for the Arkademi Team for company project. This project has various functions and requires improvements from the previous Arkademi Team tables, while still using the same database. Therefore, this marks the first stage of development for the project.
Tables Diagram
Visit here to see the detail.
Tables Description
sx5p1B_organizations
Stores data related to each organization, including details such as the organization's name, address, and contact information.
sx5p1B_users
Contains information about individual users, such as their name, email, and other personal details. It has 3 roles, which are:
super_admin_organization: A user with the same type as admin, but with more privileges that can log in to various organisations. This type of user is intended for special cases.admin_organization: Pengelola user type that acts as an admin, managing courses in the organisation.member_organization: The type of user assigned as a course participant by the admin.
sx5p1B_users_organizations
Acts as a junction table, linking users to the organizations they belong to. It stores the associations between users and organizations.
sx5p1B_user_incourse
Records which users have joined specific classes. It links users from the User table to classes from the Class table and includes details such as enrollment date, progress, and completion status.
sx5p1B_course
Contains information about the various cources offered. This includes course names, descriptions, and associated details for each courses.
sx5p1B_product
Stores pricing details for the products, including the price, discounts (sale price), and limit or stock terms that may vary depending on the organization or product type.
sx5p1B_course_listb2c
Lists all the classes available to organizations, it links to the Product table.
Writer: Media
Contributor: Kukuh
Written at: 25 October 2024