studeal
Tables (12)
BOARDS
- BOARD_ID (Key) — Primary key — NOT NULL
- USER_ID (Key2) — NUMBER(10,0) — Foreign key → USERS.USER_ID — NOT NULL
- TITLE — VARCHAR2(200) — NOT NULL
- CONTENT — VARCHAR2(2000)
- STUDENT_ID — NUMBER(10,0)
- TEACHER_ID — NUMBER(10,0)
- TYPE — VARCHAR2(10) — NOT NULL
- EXPECTED_PRICE — NUMBER(10,0) — NOT NULL
- SUBJECT — VARCHAR2(100)
- VERSION — NUMBER(10,0)
- CREATED_AT — TIMESTAMP(6)
- UPDATED_AT — TIMESTAMP(6)
- CREATED_BY — VARCHAR2(100)
- UPDATED_BY — VARCHAR2(100)
- NEGOTIATION_ID — NUMBER(10,0)
BOARD_FILES
- FILE_ID (Key) — NUMBER(10,0) — Primary key — NOT NULL
- BOARD_ID (Key2) — Foreign key → BOARDS.BOARD_ID — NOT NULL
- BOARD_ID — NUMBER(10,0) — NOT NULL
- FILE_NAME — VARCHAR2(255) — NOT NULL
- FILE_PATH — VARCHAR2(500) — NOT NULL
- FILE_TYPE — VARCHAR2(50)
- UPLOADED_AT — TIMESTAMP(6)
- IS_THUMBNAIL — VARCHAR2(1) — NOT NULL
- CREATED_AT — TIMESTAMP(6)
- UPDATED_AT — TIMESTAMP(6)
- CREATED_BY — VARCHAR2(100)
- UPDATED_BY — VARCHAR2(100)
ENROLLMENTS
- ENROLLMENT_ID (Key) — NUMBER(10,0) — Primary key — NOT NULL
- Key (Key2) — Foreign key → NEGOTIATIONS.Key — NOT NULL
- BOARD_ID (Key3) — Foreign key → NEGOTIATIONS.BOARD_ID — NOT NULL
- USER_ID (Key23) — NUMBER(10,0) — Foreign key → NEGOTIATIONS.USER_ID — NOT NULL
- STUDENT_ID — NUMBER(10,0) — NOT NULL
- NEGOTIATION_ID — NUMBER(10,0) — NOT NULL
- LESSON_ID — NUMBER(10,0) — NOT NULL
- PAID_AMOUNT — NUMBER(10,0) — NOT NULL
- ENROLLED_AT — TIMESTAMP(6) — NOT NULL
- STATUS — VARCHAR2(10) — NOT NULL
- IS_ACTIVE — VARCHAR2(1) — NOT NULL
- VERSION — NUMBER(10,0)
- CREATED_AT — TIMESTAMP(6)
- UPDATED_AT — TIMESTAMP(6)
- CREATED_BY — VARCHAR2(100)
- UPDATED_BY — VARCHAR2(100)
FAVORITES
- FAVORITE_ID (Key) — NUMBER(10,0) — Primary key — NOT NULL
- USER_ID (Key2) — NUMBER(10,0) — Foreign key → USERS.USER_ID — NOT NULL
- USER_ID — NUMBER(10,0) — NOT NULL
- NEGOTIATION_ID — NUMBER(10,0) — NOT NULL
- VERSION — NUMBER(10,0)
- CREATED_AT — TIMESTAMP(6)
- UPDATED_AT — TIMESTAMP(6)
- CREATED_BY — VARCHAR2(100)
- UPDATED_BY — VARCHAR2(100)
GRADES
- GRADE_ID (Key) — NUMBER(10,0) — Primary key — NOT NULL
- STUDENT_ID — NUMBER(10,0) — NOT NULL
- LESSON_ID — NUMBER(10,0) — NOT NULL
- SCORE — NUMBER(10,0)
- CREATED_AT — TIMESTAMP(6)
- UPDATED_AT — TIMESTAMP(6)
- CREATED_BY — VARCHAR2(100)
- UPDATED_BY — VARCHAR2(100)
LESSONS
- Key — Foreign key → NEGOTIATIONS.Key — NOT NULL
- BOARD_ID (Key3) — Foreign key → NEGOTIATIONS.BOARD_ID — NOT NULL
- USER_ID (Key23) — NUMBER(10,0) — Foreign key → NEGOTIATIONS.USER_ID — NOT NULL
- LESSON_ID — NUMBER(10,0) — NOT NULL
- TEACHER_ID — NUMBER(10,0) — NOT NULL
- NEGOTIATION_ID — NUMBER(10,0)
- TITLE — VARCHAR2(200) — NOT NULL
- DESCRIPTION — VARCHAR2(1000)
- PRICE — NUMBER(10,0) — NOT NULL
- CREATED_AT — TIMESTAMP(6)
- UPDATED_AT — TIMESTAMP(6)
- CREATED_BY — VARCHAR2(100)
- UPDATED_BY — VARCHAR2(100)
LESSON_FILES
- Key — Primary key — NOT NULL
- LESSON_ID — NUMBER(10,0) — NOT NULL
- FILE_NAME — VARCHAR2(255) — NOT NULL
- FILE_PATH — VARCHAR2(500) — NOT NULL
- FILE_TYPE — VARCHAR2(50)
- UPLOADED_AT — TIMESTAMP(6)
- IS_THUMBNAIL — VARCHAR2(1) — NOT NULL
- CREATED_AT — TIMESTAMP(6)
- UPDATED_AT — TIMESTAMP(6)
- CREATED_BY — VARCHAR2(100)
- UPDATED_BY — VARCHAR2(100)
LESSON_PRESENCES
- ATTENDANCE_ID (Key) — NUMBER(10,0) — Primary key — NOT NULL
- STUDENT_ID — NUMBER(10,0) — NOT NULL
- LESSON_ID — NUMBER(10,0) — NOT NULL
- ATTENDANCE_DATE — DATE — NOT NULL
- STATUS — VARCHAR2(10) — NOT NULL
- VERSION — NUMBER(10,0)
- CREATED_AT — TIMESTAMP(6)
- UPDATED_AT — TIMESTAMP(6)
- CREATED_BY — VARCHAR2(100)
- UPDATED_BY — VARCHAR2(100)
NEGOTIATIONS
- Key — Primary key — NOT NULL
- BOARD_ID (Key3) — Foreign key → BOARDS.BOARD_ID — NOT NULL
- USER_ID (Key23) — NUMBER(10,0) — Foreign key → BOARDS.USER_ID — NOT NULL
- STUDENT_ID — NUMBER(10,0) — NOT NULL
- TEACHER_ID — NUMBER(10,0) — NOT NULL
- PROPOSED_PRICE — NUMBER(10,0) — NOT NULL
- STATUS — VARCHAR2(10) — NOT NULL
- VERSION — NUMBER(10,0)
- CREATED_AT — TIMESTAMP(6)
- UPDATED_AT — TIMESTAMP(6)
- CREATED_BY — VARCHAR2(100)
- UPDATED_BY — VARCHAR2(100)
NEGOTIATION_FILES
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → NEGOTIATIONS.Key — NOT NULL
- BOARD_ID (Key3) — Foreign key → NEGOTIATIONS.BOARD_ID — NOT NULL
- USER_ID (Key23) — NUMBER(10,0) — Foreign key → NEGOTIATIONS.USER_ID — NOT NULL
- NEGOTIATION_ID — NUMBER(10,0) — NOT NULL
- FILE_NAME — VARCHAR2(255) — NOT NULL
- FILE_PATH — VARCHAR2(500) — NOT NULL
- FILE_TYPE — VARCHAR2(50)
- UPLOADED_AT — TIMESTAMP(6)
- IS_THUMBNAIL — VARCHAR2(1) — NOT NULL
- CREATED_AT — TIMESTAMP(6)
- UPDATED_AT — TIMESTAMP(6)
- CREATED_BY — VARCHAR2(100)
- UPDATED_BY — VARCHAR2(100)
NEGOTIATION_PARTICIPANTS
- Key — Primary key — NOT NULL
- ID — NUMBER(10,0) — NOT NULL
- NEGOTIATION_ID — NUMBER(10,0) — NOT NULL
- USER_ID — NUMBER(10,0) — NOT NULL
- ROLE — VARCHAR2(10) — NOT NULL
- STATUS — VARCHAR2(10) — NOT NULL
- CREATED_AT — TIMESTAMP(6)
- UPDATED_AT — TIMESTAMP(6)
- CREATED_BY — VARCHAR2(100)
- UPDATED_BY — VARCHAR2(100)
USERS
- USER_ID (Key) — NUMBER(10,0) — Primary key — NOT NULL
- ROLE — VARCHAR2(10) — NOT NULL
- NAME — VARCHAR2(50) — NOT NULL
- EMAIL — VARCHAR2(100) — NOT NULL
- PASSWORD — VARCHAR2(255) — NOT NULL
- BIO — VARCHAR2(1000)
- RATING — NUMBER(10,0)
- MAJOR — VARCHAR2(100)
- GRADE_LEVEL — NUMBER(10,0)
- VERSION — NUMBER(10,0)
- CREATED_AT — TIMESTAMP(6)
- UPDATED_AT — TIMESTAMP(6)
- CREATED_BY — VARCHAR2(100)
- UPDATED_BY — VARCHAR2(100)