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