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)