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