DLAB

테이블 (32)

CATEGORY

  • 카테고리 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • CATEGORY_NAME — VARCHAR(255) — NOT NULL
  • CATEGORY_ORDER — INTEGER — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR(255) — NOT NULL
  • POST_STATUS — VARCHAR(255) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR(255)

ORGANIZATION

  • ORGANIAZTION_ID (ID) — BIGINT — 기본 키 — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • NAME — VARCHAR(255) — NOT NULL
  • UPDATED_AT — TIMESTAMP

QNA 문의 (QNA)

  • ID — BIGINT — NOT NULL
  • ANSWERER — VARCHAR(255)
  • BODY — VARCHAR(255) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR(255)
  • IS_ANSWERED — BOOLEAN
  • IS_DELETED — BOOLEAN
  • TITLE — VARCHAR(255) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR(255)
  • 멤버 ID (MEMBER_ID) — BIGINT — 외래 키 → 회원.멤버 ID — NOT NULL

강의 (EDU_LECTURE)

  • 강의 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • SCHEDULE_ORDER — INTEGER — NOT NULL
  • PLACE — VARCHAR(255) — NOT NULL
  • LECTURE_DATE — DATE — NOT NULL
  • START_DATE — TIMESTAMP — NOT NULL
  • END_DATE — TIMESTAMP
  • 코스 회차 ID (EDU_COURSE_ID) — BIGINT — 외래 키 → 코스 회차.코스 회차 ID — NOT NULL

결제 내역 (PAYMENT_HISTORY)

  • 결제 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • APPROVED_AT — TIMESTAMP — NOT NULL
  • CANCELLED_AT — TIMESTAMP — NOT NULL
  • CREDIT_CARD_COMPANY — VARCHAR(255) — NOT NULL
  • CREDIT_CARD_NUMBER — VARCHAR(255) — NOT NULL
  • LAB_LOCATION — INTEGER — NOT NULL
  • STATUS — INTEGER — NOT NULL
  • PROGRAM_TITLE — VARCHAR(255) — NOT NULL
  • 예약 ID (RESERVATION_ID) — BIGINT

공지 (NOTICE)

  • 공지 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • BODY — VARCHAR(255) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR(255) — NOT NULL
  • ENDED_AT — TIMESTAMP
  • IS_DELETED — BOOLEAN — NOT NULL
  • IS_IMPORTANT — BOOLEAN
  • LAB_LOCATION — VARCHAR(255) — NOT NULL
  • NOTICE_TYPE — VARCHAR(255) — NOT NULL
  • POST_STATUS — VARCHAR(255) — NOT NULL
  • STARTED_AT — TIMESTAMP
  • TITLE — VARCHAR(255) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR(255)

교육 콘텐츠 (EDU_CONTENT)

  • 교육 콘텐츠 id (ID) — BIGINT — 기본 키 — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR(255)
  • DESCRIPTION — CLOB
  • IS_DELETED — BOOLEAN — NOT NULL
  • POST_END — DATE
  • POST_START — DATE
  • STATUS — VARCHAR(255) — NOT NULL
  • THUMBNAIL_ID — BIGINT
  • TITLE — VARCHAR(100) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR(255)

권한 (AUTH)

  • 권한 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • MEMBER_ROLE — VARCHAR(255) — NOT NULL
  • MEMBER_ID — BIGINT
  • 멤버 ID (ID2) — BIGINT — 외래 키 → 회원.멤버 ID — NOT NULL

로그인 내역 (LOGIN_HISTORY)

  • 로그인 내역 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • IP — VARCHAR(255)
  • LOGGED_IN_AT — TIMESTAMP — NOT NULL
  • MEMBER_ID — BIGINT — NOT NULL
  • REQUEST_URL — VARCHAR(255)
  • USERNAME — VARCHAR(50) — NOT NULL

마스터 프로그램 (EDU_PROGRAM)

  • 프로그램 id (ID) — BIGINT — 기본 키 — NOT NULL
  • CODE — VARCHAR(255) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • DESCRIPTION — CLOB
  • FILES — VARCHAR(255)
  • INTRODUCTION — VARCHAR(100) — NOT NULL
  • STATUS — VARCHAR(255) — NOT NULL
  • PROGRAM_TYPE — VARCHAR(255) — NOT NULL
  • RECOMMENDATION_TARGET — VARCHAR(255)
  • THUMBNAIL_ID — BIGINT
  • TITLE — VARCHAR(50) — NOT NULL
  • UPDATED_AT — TIMESTAMP

방문 예약 (VISIT_SCHEDULE)

  • 방문예약 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • CAPACITY — SMALLINT — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR(255)
  • LAB_LOCATION — VARCHAR(255) — NOT NULL
  • TYPE — VARCHAR(255) — NOT NULL
  • STATUS — INTEGER — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR(255)
  • VISIT_DATE — DATE — NOT NULL

방문 예약 상세 (VISIT_DETAIL_SCHEDULE)

  • 방문예약상세 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • CAPACITY — SMALLINT — NOT NULL
  • END_TIME — TIMESTAMP
  • START_TIME — TIMESTAMP — NOT NULL
  • 방문예약 ID (VISIT_SCHEDULE_ID) — BIGINT — 외래 키 → 방문 예약.방문예약 ID — NOT NULL

본인인증 토큰 정보 (IDENTIFICATION_CRYPTO_TOKEN)

  • 본인인증 토큰정보 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • ENC_DATA — VARCHAR(255) — NOT NULL
  • INTEGRITY_VALUE — VARCHAR(255) — NOT NULL
  • IV — VARCHAR(255) — NOT NULL
  • PERIOD — BIGINT — NOT NULL
  • REQ_DTIM — VARCHAR(255) — NOT NULL
  • SECURE_KEY — VARCHAR(255) — NOT NULL
  • TOKEN_VAL — VARCHAR(255) — NOT NULL
  • TOKEN_VERSION_ID — VARCHAR(255) — NOT NULL

비밀번호 찾기 링크 (PASSWORD_LINK)

  • 비밀번호 링크 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • PASSWORD_CHANGED — BOOLEAN — NOT NULL
  • RESET_KEY — VARCHAR(255) — NOT NULL
  • USERNAME — VARCHAR(50) — NOT NULL

설문 (SURVEY)

  • 설문 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • DESCRIPTION — VARCHAR(255)
  • POSITIONS — VARCHAR(255)
  • STATUS — INTEGER
  • TITLE — VARCHAR(255) — NOT NULL

설문 문제 (SURVEY_QUESTION)

  • 설문 문제 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • KIND — INTEGER
  • RAW_CONTENT — VARCHAR(4000)
  • 설문 ID (SURVEY_ID) — BIGINT — 외래 키 → 설문.설문 ID — NOT NULL

설문 문제 답변 (SURVEY_QUESTION_ANSWER)

  • 설문 문제 답변 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • RAW_ANSWERS — VARCHAR(4000)
  • 설문 응답 ID (QUESTION_ID) — BIGINT — 외래 키 → 설문 응답.설문 응답 ID — NOT NULL

설문 응답 (SURVEY_RESPONSE)

  • 설문 응답 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • IP_ADDRESS — VARCHAR(255)
  • RESPONDENT_EMAIL — VARCHAR(255)
  • 설문 ID (SURVEY_ID) — BIGINT — 외래 키 → 설문.설문 ID — NOT NULL

예약 알림 (BOOKABLE_NOTIFICATION)

  • 예약알림 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • PHONE_NUMBER — VARCHAR(255) — NOT NULL
  • STATUS — VARCHAR(255) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • EDU_COURSE_ID — BIGINT — NOT NULL
  • 예약 ID (RESERVATION ID) — BIGINT — 외래 키 → 예약정보.예약 ID — NOT NULL
  • 멤버 ID (MEMBER ID) — BIGINT — 외래 키 → 회원.멤버 ID — NOT NULL

예약변경 내역 (RESERVATION_CHANGE_HISTORY)

  • 예약변경 내역 id (ID) — BIGINT — 기본 키 — NOT NULL
  • CHANGE — VARCHAR(255) — NOT NULL
  • CHANGED_AT — TIMESTAMP — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR(255)
  • FULL_NAME — VARCHAR(255) — NOT NULL
  • HISTORY_TYPE — VARCHAR(255) — NOT NULL
  • USER_ROLE — VARCHAR(255) — NOT NULL
  • PREVIOUS — VARCHAR(255) — NOT NULL
  • USERNAME — VARCHAR(255) — NOT NULL
  • RESERVATION_ID — BIGINT — 외래 키 → 예약정보.예약 ID — NOT NULL

예약정보 (RESERVATION)

  • 예약 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • ADDITIONAL_CANCEL_EXPLAIN — VARCHAR(255)
  • APPLICATION_FILE — BIGINT
  • CANCEL_REASON — VARCHAR(255)
  • CANCEL_TYPE — VARCHAR(255)
  • CANCELLED_AT — TIMESTAMP
  • CHANNEL_TYPE — VARCHAR(255) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • DISCOUNT_PERCENTAGE — SMALLINT
  • DISCOUNT_TYPE — VARCHAR(255)
  • EMAIL — VARCHAR(255) — NOT NULL
  • GROUP_NAME — VARCHAR(255)
  • LAB_LOCATION — VARCHAR(255) — NOT NULL
  • NAME — VARCHAR(255) — NOT NULL
  • NUMBER_OF_PARTICIPANTS — INTEGER — NOT NULL
  • PARTICIPANTS_FILE — BIGINT
  • PAYMENT — INTEGER — NOT NULL
  • PHONE_NUMBER — VARCHAR(255) — NOT NULL
  • REJECTION_TYPE — INTEGER
  • RESERVATION_FOR — VARCHAR(255) — NOT NULL
  • RESERVATION_NUMBER — VARCHAR(255) — NOT NULL
  • STATUS — VARCHAR(255) — NOT NULL
  • TYPE — VARCHAR(255) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • CHARGE_TYPE — VARCHAR(255)
  • PRICE — INTEGER
  • RESERVED_AT — TIMESTAMP
  • 멤버키 (MEMBER_ID) — BIGINT — 외래 키 → 회원.멤버 ID — NOT NULL
  • 방문예약상세 ID (VISIT_DETAIL_SCHEDULE_ID) — BIGINT — 외래 키 → 방문 예약 상세.방문예약상세 ID — NOT NULL
  • 코스 회차 ID (EDU_COURSE_ID) — BIGINT — 외래 키 → 코스 회차.코스 회차 ID — NOT NULL

자주묻는 질문 (FAQ)

  • FAQ ID (ID) — BIGINT — 기본 키 — NOT NULL
  • BODY — VARCHAR(255) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR(255) — NOT NULL
  • FAQ_ORDER — INTEGER — NOT NULL
  • IS_DELETED — BOOLEAN — NOT NULL
  • TITLE — VARCHAR(255) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR(255)
  • 카테고리 ID (CATEGORY_ID) — BIGINT — 외래 키 → CATEGORY.카테고리 ID — NOT NULL

전시 체험 (EXHIBITION_EXPERIENCE)

  • 전시 체험 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR(255)
  • POST_END_DATE — DATE
  • EXPLAIN — VARCHAR(255)
  • IMAGE1 — BIGINT
  • IMAGE2 — BIGINT
  • IMAGE3 — BIGINT
  • LAB_LOCATION — VARCHAR(255) — NOT NULL
  • POSITION — SMALLINT
  • START_DATE — DATE
  • POST_STATUS — VARCHAR(255) — NOT NULL
  • TITLE — VARCHAR(255)
  • EXHIBITION_EXPERIENCE_TYPE — VARCHAR(255)
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR(255)
  • POST_START_DATE — DATE

지역 프로그램 (EDU_REGION_PROGRAM)

  • 지역 프로그램 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • APPLICATION_TYPE — VARCHAR(255) — NOT NULL
  • CHARGE_TYPE — VARCHAR(255) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • LAB_LOCATION — VARCHAR(255) — NOT NULL
  • POST_END — DATE
  • POST_START — DATE
  • POST_STATUS — VARCHAR(255) — NOT NULL
  • REGISTRATION_STATUS — INTEGER — NOT NULL
  • TERM_TYPE — VARCHAR(255) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • 프로그램 id (EDU_PROGRAMS_ID) — BIGINT — 외래 키 → 마스터 프로그램.프로그램 id — NOT NULL

채용 (RECRUITMENT)

  • 채용 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • CONTENT — VARCHAR(255) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR(255) — NOT NULL
  • IS_DELETED — BOOLEAN — NOT NULL
  • END — DATE
  • HAS_PERIOD — BOOLEAN — NOT NULL
  • LAB_LOCATION — VARCHAR(255) — NOT NULL
  • POSITION — INTEGER
  • POST_END — DATE
  • POST_START — DATE
  • POST_STATUS — VARCHAR(255)
  • START — DATE
  • TITLE — VARCHAR(255) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR(255)
  • RECRUIT_END — DATE
  • RECRUIT_START — DATE

추천 프로그램 (RECOMMEND_PROGRAM)

  • 추천 프로그램 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • END_DATE — DATE
  • POSITION — INTEGER — NOT NULL
  • STATUS — VARCHAR(255) — NOT NULL
  • START_DATE — DATE
  • UPDATED_AT — TIMESTAMP
  • WEB_TYPE — VARCHAR(255) — NOT NULL
  • 지역 프로그램 ID (EDU_REGION_PROGRAM_ID) — BIGINT — 외래 키 → 지역 프로그램.지역 프로그램 ID — NOT NULL

코스 회차 (EDU_COURSE)

  • 코스 회차 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • BENEFITS — VARCHAR(255)
  • CAPACITY — INTEGER — NOT NULL
  • CHARGE_TYPE — VARCHAR(255) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • POST_STATUS — VARCHAR(255) — NOT NULL
  • PRICE — INTEGER
  • RESERVATION_REGISTRATION_END — DATE — NOT NULL
  • RESERVATION_REGISTRATION_START — DATE — NOT NULL
  • TYPE — VARCHAR(255) — NOT NULL
  • STATUS — VARCHAR(255) — NOT NULL
  • TITLE — VARCHAR(20) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • 지역 프로그램 ID (EDU_REGION_PROGRAM_ID) — BIGINT — 외래 키 → 지역 프로그램.지역 프로그램 ID — NOT NULL

프로그램 카테고리 (PROGRAM_CATEGORY)

  • 카테고리 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • NAME — VARCHAR(20) — NOT NULL

프로그램 카테고리 매핑 (PROGRAM_CATEGORY_MAPPING)

  • 프로그램 카테고리 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • EDU_PROGRAM_ID — BIGINT
  • PROGRAM_CATEGORY_ID — BIGINT
  • 프로그램 id (ID2) — BIGINT — 외래 키 → 마스터 프로그램.프로그램 id — NOT NULL
  • 카테고리 ID (ID3) — BIGINT — 외래 키 → 프로그램 카테고리.카테고리 ID — NOT NULL

학교 알리미 (SCHOOL_INFO)

  • 학교알리미 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • ADRCD_NM — VARCHAR(255)
  • COEDU_SC_CODE — VARCHAR(255)
  • SCHUL_KND_SC_CODE — VARCHAR(255)
  • SCHUL_NM — VARCHAR(255)
  • SCHUL_RDNDA — VARCHAR(255)
  • SCHUL_RDNMA — VARCHAR(255)
  • SCHUL_RDNZC — VARCHAR(255)
  • USER_TELNO — VARCHAR(255)
  • USER_TELNO_GA — VARCHAR(255)
  • USER_TELNO_SW — VARCHAR(255)

회원 (MEMBER)

  • 멤버 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • BIRTH_DATE — DATE
  • BLACK_LIST_REASON — VARCHAR(255)
  • CREATED_AT — TIMESTAMP — NOT NULL
  • DELETED_AT — TIMESTAMP
  • EMAIL — VARCHAR(100)
  • FULL_NAME — VARCHAR(50)
  • GUARDIAN_AGREED — BOOLEAN
  • GUARDIAN_BIRTH_DATE — DATE
  • GUARDIAN_NAME — VARCHAR(50)
  • GUARDIAN_PHONE — VARCHAR(50)
  • LAST_LOGGED_IN_AT — TIMESTAMP
  • MARKETING_MAIL — BOOLEAN
  • MARKETING_SMS — BOOLEAN
  • MEMBER_TYPE — VARCHAR(255) — NOT NULL
  • PASSWORD — VARCHAR(255)
  • PHONE_NUMBER — VARCHAR(50)
  • PRIVACY_AGREED — BOOLEAN
  • ROLE_LAST_MODIFIED_AT — TIMESTAMP
  • STATUS — VARCHAR(255) — NOT NULL
  • STATUS_CHANGED_AT — TIMESTAMP
  • TERMS_AGREED — BOOLEAN
  • UPDATED_AT — TIMESTAMP
  • USERNAME — VARCHAR(50) — NOT NULL
  • VERIFIED — BOOLEAN
  • WITHDRAWAL_REASON — VARCHAR(255)

휴관 달력 (LAB_CALENDAR)

  • 휴관 달력 ID (ID) — BIGINT — 기본 키 — NOT NULL
  • CLOSED_DAY_TYPE — VARCHAR(255)
  • CREATED_AT — TIMESTAMP — NOT NULL
  • ETC_DAY_TYPE — VARCHAR(255)
  • HOLIDAY_TYPE — VARCHAR(255)
  • LAB_CALENDAR_DATE — DATE — NOT NULL
  • LAB_LOCATION — VARCHAR(255) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • DAY_TYPE — VARCHAR(255) — NOT NULL