onboarding

Tables (11)

ANSWER

  • ANSWER_ID — BIGINT — Primary key — NOT NULL
  • ANSWER — VARCHAR
  • QUESTION_ID — BIGINT — Foreign key → QUESTION.QUESTION_ID — NOT NULL
  • RESERVATION_ID — BIGINT — Foreign key → RESERVATION.RESERVATION_ID — NOT NULL

CANCEL

  • CANCEL_ID — BIGINT — Primary key — NOT NULL
  • CANCEL_REASON — VARCHAR
  • REASON (REASOn) — VARCHAR
  • PROGRAM_ID — BIGINT — Foreign key → MENTORING.PROGRAM_ID — NOT NULL

EVENT

  • EVENT_ID — BIGINT — Primary key — NOT NULL
  • NAME — VARCHAR
  • LOGO_IMAGE — VARCHAR
  • POSTER_IMAGE — VARCHAR
  • DESCRIPTION — VARCHAR

EXPERT

  • EXPERT_ID — BIGINT — Primary key — NOT NULL
  • NAME — VARCHAR
  • UNIVERSITY — VARCHAR
  • FIELD — VARCHAR
  • DEPARTMENT — VARCHAR
  • ROLE — ENUM(UNIVERSITY_STUDENT, EXPERT)

EXPERT_PROGRAM

  • EXPERT_PROGRAM_ID — BIGINT — Primary key — NOT NULL
  • EXPERT_ID — BIGINT — Foreign key → EXPERT.EXPERT_ID — NOT NULL
  • PROGRAM_ID — BIGINT — Foreign key → MENTORING.PROGRAM_ID — NOT NULL

MENTORING

  • PROGRAM_ID — BIGINT — Primary key — NOT NULL
  • NAME — VARCHAR
  • DURATION — INT
  • LOCATION — VARCHAR
  • START_DATE — LOCALDATE
  • END_DATE — LOCALDATE
  • DESCRIPTION — VARCHAR
  • EVENT_ID — BIGINT — Foreign key → EVENT.EVENT_ID — NOT NULL

POSSIBLE_TIME (PPOSSIBLE_TIME)

  • POSSIBLE_TIME_ID — BIGINT — Primary key — NOT NULL
  • WEEK — ENUM(MON, TUE, WED, THUR, FRI, SAT, SUN)
  • START_TIME — TIME
  • END_TIME — TIME
  • EXPERT_ID — BIGINT — Foreign key → EXPERT.EXPERT_ID — NOT NULL

QUESTION

  • QUESTION_ID — BIGINT — Primary key — NOT NULL
  • QUESTION — VARCHAR
  • EXPERT_ID — BIGINT — Foreign key → EXPERT.EXPERT_ID — NOT NULL

RESERVATION

  • RESERVATION_ID — BIGINT — Primary key — NOT NULL
  • EXPIRED_AT — LOACALDATETIME
  • STUDENT_ID — BIGINT — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • TIME_TABLE_ID — BIGINT — Foreign key → TIME_TABLE.TIME_TABLE_ID — NOT NULL

STUDENT

  • STUDENT_ID — BIGINT — Primary key — NOT NULL
  • NAME — VARCHAR
  • PHONE_NUMBER (PHONE_NJUMBER) — VARCHAR
  • STUDENT_NUMBER — VARCHAR

TIME_TABLE

  • TIME_TABLE_ID — BIGINT — Primary key — NOT NULL
  • START_DATE_TIME — LOCALDATETIME
  • STATUS — ENUM(PENDING, BOOKED, AVAILABLE, DONE)
  • EXPERT_PROGRAM_ID — BIGINT — Foreign key → EXPERT_PROGRAM.EXPERT_PROGRAM_ID — NOT NULL