s
Tables (22)
AD_PRODUCT_TBL
- AP_IDX — int(11) — Primary key — NOT NULL
- AP_PRODUCT_CODE — varchar(50)
- AP_RECRUIT_TYPE — int(11)
- AD_PRODUCT_NAME — int(11)
- AD_MISSION_TYPE — int(11)
- AD_MISSION_TIME — int(11)
- AD_PRICE_TYPE — int(11)
- AD_PRICE — int(11)
- AD_THUMB_IMG — varchar(255)
- AD_THUMB_PATH — varchar(255)
- AD_B2B_PRODUCT_DESC — text
- AD_B2C_PRODUCT_DESC — text
- AD_CREATE_DT — int(11) — timestamp
- AD_CREATE_ID — varchar(100)
- AD_CREATE_IP — varchar(25)
- AD_MODIFY_DT — int(11) — timestamp
- AD_MODIFY_ID — varchar(100)
- AD_MODIFY_IP — varchar(25)
- AD_DEL_DT — int(11) — timestamp
- AD_DEL_ID — varchar(100)
- AD_DEL_IP — varchar(25)
- AD_DEL_YN — enum — Y,N
BANNER_TBL
- BANNER_IDX — int(11) — Primary key — NOT NULL
- BANNER_TYPE — tinyint(10) — 1 : B2C 2 : B2B
- BANNER_START_DT — int(11) — timestamp
- BANNER_END_DT — int(11) — timestamp
- BANNER_TITLE — varchar(100)
- BANNER_CONTENT — text
- BANNER_TARGET_LINK — varchar(255)
- BANNER_IMG — varchar(255)
- BANNER_PATH — varchar(255)
- BANNER_VIEW_YN — enum — Y,N
- BANNER_VIEW_ORDER — int
- BANNER_FLAG — tinyint(10)
- BANNER_CREATE_DT — int(11) — timestamp
- BANNER_CREATE_ID — varchar(100)
- BANNER_CREATE_IP — varchar(25)
- BANNER_MODIFY_DT — int(11) — timestamp
- BANNER_MODIFY_ID — varchar(100)
- BANNER_MODIFY_IP — varchar(25)
- BANNER_DEL_DT — int(11) — timestamp
- BANNER_DEL_ID — varchar(100)
- BANNER_DEL_IP — varchar(25)
- BANNER_DEL_YN — enum — Y,N
CATEGORY_DEPTH_TBL
- CD_INDEX — int(11) — Primary key — NOT NULL
- CD_CODE — varchar(50)
- CD_DEPTH1 — int(11) — CATEGORY_IDX
- CD_DEPTH2 — int(11) — CATEGORY_IDX
- CD_DEPTH3 — int(11) — CATEGORY_IDX
- CD_DEPTH4 — int(11) — CATEGORY_IDX
- CD_DEPTH5 — int(11) — CATEGORY_IDX
- CD_FACTOR — varchar(100)
- CD_CHECK — enum
- CD_NON_CHECK — enum
- CD_CREATE_DT — int(11) — timestamp
- CD_CREATE_ID — varchar(100)
- CD_CREATE_IP — varchar(25)
- CD_MODIFY_DT — int(11) — timestamp
- CD_MODIFY_ID — varchar(100)
- CD_MODIFY_IP — varchar(25)
- CD_DEL_DT — int(11) — timestamp
- CD_DEL_ID — varchar(100)
- CD_DEL_IP — varchar(25)
- CD_DEL_YN — enum — Y,N
CATEGORY_TBL
- CATEGORY_IDX — int(11) — Primary key — NOT NULL
- CATEGORY_NAME — varchar(100)
- CATEGORY_KEYWORD — text
- CATEGORY_CREATE_DT — int(11) — 회면에는 노출안함 timestamp
- CATEGORY_CREATE_ID — varchar(100) — timestamp
- CATEGORY_CREATE_IP — varchar(25)
- CATEGORY_DEL_DT — int(11) — timestamp
- CATEGORY_DEL_ID — varchar(100)
- CATEGORY_DEL_IP — varchar(25)
- CATEGORY_DEL_YN — enum — Y,N
COMPANY_QUOTATION_CART_TBL
- CQC_IDX — int(11) — Primary key — NOT NULL
- COMPANY_IDX — int(11) — Foreign key → COMPANY_TBL.COMPANY_IDX — NOT NULL
- COMPANY_CODE — varchar(50) — Foreign key → COMPANY_TBL.COMPANY_CODE — NOT NULL
COMPANY_QUOTATION_SAVE_TBL
- CQS_IDX — int(11) — Primary key — NOT NULL
- CQ_IDX — int(11) — Foreign key → COMPANY_QUOTATION_TBL.CQ_IDX — NOT NULL
- CQS_SAVE_NAME — varchar(255)
- CQS_CREATE_DT — int(11)
COMPANY_QUOTATION_TBL
- CQ_IDX — int(11) — Primary key — NOT NULL
- CQ_TYPE — tinyint(3) — 1: 모집형, 2:타겟형
- AP_IDX — int(11) — NOT NULL
- CQ_STATUS — tinyint(3) — 검수중, 승인, 반려, 참가자모집, 미션중, 일시중지, 미션완료
- Field — VARCHAR(255)
COMPANY_TBL
- COMPANY_IDX — int(11) — Primary key — NOT NULL
- COMPANY_CODE — varchar(50) — Primary key — NOT NULL
- COMPANY_CATEGORY — tinyint(3) — 1: 개인, 2: 법인
- COMPANY_ID — varchar(100)
- COMPANY_PASS — varchar(255) — sha256 암호화
- COMPANY_CERT_YN — enum — Y,N
- COMPANY_NUMBER — varchar(30)
- COMPANY_NAME — varchar(100)
- COMPANY_CEO_NAME — varchar(100)
- Field13 — VARCHAR(255)
- COMPANY_TEL — varchar(30)
- COMPANY_EMAIL — varchar(255)
- COMPANY_ZIP_CODE — int(11)
- COMPANY_ADDRESS — varchar(255)
- COMPANY_ADDRESS2 — varchar(255)
- COMPANY_IMG — varchar(255)
- COMPANY_PATH — varchar(255)
- COMPANY_DPT_NAME — varchar(100)
- COMPANY_DPT_CELL — varchar(30)
- COMPANY_DTP_IMG — varchar(255)
- COMPANY_DTP_PATH — varchar(255)
- COMPANY_DTP_NAME — varchar(50)
- COMPANY_DTP_POSITION — varchar(30)
- COMPNAY_DTP_TEL — varchar(30)
- COMPANY_USE_YN — enum — Y,N
- COMPANY_INFO_YN — enum — Y,N
- COMPANY_INFO2_YN — enum — Y,N
- COMPANY_MARKETING_YN — enum — Y,N
- COMPANY_14OLD_YN — enum — Y,N
- COMPANY_LAST_LOGIN_DT — int(11)
- COMPANY_CHANGE_PASS_DT — int(11) — 정책이 있는지 모르겠음
- COMPANY_CREATE_DT — int(11) — timestamp
- COMPANY_CREATE_IP — varchar(25)
- COMPANY_MODIFY_DT — inf(11) — timestamp
- COMPANY_MODIFY_ID — varchar(100)
- COMPANY_MODIFY_IP — varchar(25)
- COMPANY_DEL_DT — int(11) — timestamp
- COMPANY_DEL_ID — varchar(100)
- COMPANY_DEL_IP — varchar(25)
- COMPANY_DEL_YN — enum — Y,N
- COMPANY_PUSH_TIME — int(11) — 인증 정보 입력 완료>관리자에게 푸쉬 전송
- Field — VARCHAR(255)
EVENT_RESULT_TBL
- ER_IDX — int(11) — Primary key — NOT NULL
- EVENT_IDX — int(11) — Foreign key → EVENT_TBL.EVENT_IDX — NOT NULL — 기본키
- ER_MEMBER_IDX — int(11) — NOT NULL
- ER_POINT — int(11)
- ER_EVENT_DT — int(11) — timestamp
EVENT_TBL
- EVENT_IDX — int(11) — Primary key — NOT NULL — 기본키
- EVENT_TITLE — varchar(255)
- EVENT_CONTENT — text(0)
- EVENT_TARGET — varchar(100) — NOT NULL — 옵션이 늘어날 여지 있음
- EVENT_START_DT — int(11)
- EVENT_END_DT — int(11)
- EVENT_LINK — varchar(255)
- EVENT_POINT_YN — enum — Y,N
- EVENT_POINT — int(11)
- EVENT_BUDGET — int(11)
- EVENT_VIEW_YN — enum — Y,N
- EVENT_THUMB_IMG — varchar(255) — 파일명
- EVENT_THUMB_PATH — varchar(255) — 파일경로_업로드파일명
- EVENT_END_TYPE — tinyint(10) — 1:예산 2:기간
- EVENT_WRITER_ID — varchar(100)
- EVENT_WRITER_NAME — varchar(50)
- EVENT_CREATE_DT — int(11) — timestamp
- EVENT_CREATE_IP — varchar(25)
- EVENT_MODIFY_DT — int(11) — timestamp
- EVENT_MODIFY_IP — varchar(25)
- EVENT_MODIFY_ID — varchar(100)
- EVENT_DEL_DT — int(11) — timestamp
- EVENT_DEL_ID — varchar(100)
- EVENT_DEL_IP — varchar(25)
- EVENT_DEL_YN — enum — Y,N
FAQ_TBL
- FAQ_IDX — int(11) — Primary key — NOT NULL
- FAQ_TYPE — tinyint(3) — 0 : 전체 1 : B2C 2 : B2B
- FAQ_QUESTION — text
- FAQ_ANSWER — text
- FAQ_WRITE_DT — int(11) — timestamp
- FAQ_CREATE_ID — varchar(100)
- FAQ_CREATE_IP — varchar(25)
- FAQ_MODIFY_DT — int(11) — timestamp
- FAQ_MODIFY_ID — varchar(100)
- FAQ_MODIFY_IP — varchar(25)
- FAQ_DEL_DT — int(11) — timestamp
- FAQ_DEL_ID — varchar(100)
- FAQ_DEL_IP — varchar(25)
- FAQ_DEL_YN — enum — Y, N
FUNCTION_DESCRIPTION_TBL
- FD_IDX — int(11) — Primary key — NOT NULL — pk
- FD_TYPE — tinyint(11) — 1 : B2C 2 : B2B
- FD_CODE — varchar(50)
- FD_CALL — varchar(50)
- FD_CONTENT — text
- FD_CREATE_DT — int(11) — timestamp
- FD_CREATE_ID — varchar(100)
- FD_CREATE_IP — varchar(25)
- FD_MODIFY_DT — int(11) — timestamp
- FD_MODIFY_ID — varchar(100)
- FD_MODIFY_IP — varchar(25)
- FD_DEL_DT — int(11) — timestamp
- FD_DEL_ID — varchar(100)
- FD_DEL_IP — varchar(25)
- FD_DEL_YN — enum — Y,N
INQUIRY_TBL
- INQUIRY_IDX — int(11) — Primary key — NOT NULL
- INQUIRY_TYPE — tinyint(3) — 1 : B2C 2 : B2B
- INQUIRY_WRITER_CODE — varchar(100)
- INQUIRY_QUESTION_TYPE — tinyint(3)
- INQUIRY_TITLE — varchar(100)
- INQUIRY_CONTENT — text
- INQUIRY_REPLY — text
- INQUIRY_REPLY_ID — varchar(100)
- INQUIRY_REPLY_DT — int(11) — timestamp
- INQUIRY_STATUS — tinyint(3) — 접수, 답변
- INQUIRY_CREATE_DT — int(11) — timestamp
- INQUIRY_CREATE_IP — varchar(25)
- INQUIRY_MODIFY_DT — int(11) — timestamp
- INQUIRY_MODIFY_ID — varchar(100)
- INQUIRY_MODIFY_IP — varchar(25)
- INQUIRY_DEL_DT — int(11) — timestamp
- INQUIRY_DEL_ID — varchar(100)
- INQUIRY_DEL_IP — varchar(25)
- INQUIRY_DEL_YN — enum — Y,N
MARGIN_TBL
- MARGIN_IDX — int(11) — Primary key — NOT NULL
- MARGIN_DT — int(11)
- MARGIN_LEVEL — tinyint(3)
- MARGIN_B2C_CHARGE — tinyint(3)
- MARGIN_B2C_STAR_POINT — int(11)
- MARGIN_B2C_STAR_BONUS — tinyint(3)
- MARGIN_B2C_ROUND_FRIEND — int(11)
- MARGIN_B2C_ROUND_BONUS — tinyint(3)
- MARGIN_B2C_BADGE_ATTEND — int(11)
- MARGIN_B2C_BADGE_BONUS — tinyint(3)
- MARGIN_B2B_PAY — tinyint(3)
- MARGIN_B2B_DISCOUNT — tinyint(3)
- MARGIN_CREATE_ID — varchar(100)
- MARGIN_CREATE_IP — varchar(25)
- MARGIN_DEL_DT — int(11) — timestamp
- MARGIN_DEL_ID — varchar(100)
- MARGIN_DEL_IP — varchar(25)
- MARGIN_DEL_YN — enum — Y,N
MEMBER_ATTEND_TBL
- MA_IDX — int(11) — Primary key — NOT NULL — pk
- MEMBER_CODE — varchar(50) — Foreign key → MEMBER_TBL.MEMBER_CODE — NOT NULL
- MA_CHECK_IN — int(11) — timestamp
MEMBER_MBTI_TBL
- MM_IDX — int(11) — Primary key — NOT NULL
- MEMBER_CODE — varchar(50) — Foreign key → MEMBER_TBL.MEMBER_CODE — NOT NULL
- MM_STATUS — tinyint(3) — 1: 등록, 2:수정, 3:삭제
- MM_MBTI — char(10)
- MM_CONTENT — varchar(100) — 2회 이상 정보 수정시
- MM_CREATE_DT — int(11) — timestamp
MEMBER_POINT_TBL
- MP_IDX — int(11) — Primary key — NOT NULL — pk
- MEMBER_CODE — varchar(50) — Foreign key → MEMBER_TBL.MEMBER_CODE — NOT NULL
- MP_STATUS — tinyint(3) — 사용, 미사용
- MP_TYPE — VARCHAR(255) — 신규가입, 출석, 포인트 룰렛, 정보 수집 등등
- MP_POINT — int(11)
- MP_CREATE_DT — int(11) — timestamp
MEMBER_TBL
- MEMBER_IDX — int(11) — Primary key — NOT NULL — pk
- MEMBER_CODE — varchar(50) — Primary key — NOT NULL
- MEMBER_ID — varchar(100)
- MEMBER_PW — varchar(255) — SHA256
- MEMBER_NAME — varchar(100)
- MEMBER_NICKNAME — varchar(100)
- MBMBER_CERT_EMAIL — varchar(255)
- MEMBER_CELL — varchar(30)
- MEMBER_JOIN_CHANNEL — varchar(30)
- MEMBER_LAST_LOGIN_DT — int(11) — timestamp
- MEMBER_INTRODUCE_CODE — varchar(50)
- MEMBER_ADMIN_MEMO — text
- MEMBER_14OLD_YN — enum — Y,N
- MEMBER_USE_YN — enum — Y,N
- MEMBER_INFO_YN — enum — Y,N
- MEMBER_INFO2_YN — enum — Y,N
- MEMBER_SERVICE_APP_PUSH_YN — enum — Y,N
- MEMBER_SERVICE_EMAIL_YN — enum — Y,N
- MEMBER_APP_PUSH_YN — enum — Y,N
- MEMBER_EMAIL_YN — enum — Y,N
- MEMBER_REMOVE_POINT_YN — enum — Y,N
- MEMBER_CREATE_DT — int(11) — timestamp
- MEMBER_CREATE_IP — varchar(25)
- MEMBER_MODIFY_DT — int(11) — timestamp
- MEMBER_MODIFY_ID — varchar(100)
- MEMBER_MODIFY_IP — varchar(25)
- MEMBER_DEL_DT — int(11) — timestamp
- MEMBER_DEL_ID — varchar(100)
- MEMBER_DEL_IP — varchar(25)
- MEMBER_DEL_YN — enum — Y,N
REPORT_TBL
- REPORT_IDX — int(11) — Primary key — NOT NULL
- REPORT_FROM_CODE — varchar(50) — Primary key — NOT NULL
- REPORT_TO_CODE — varchar(50) — Primary key — NOT NULL
- REPORT_TYPE — tinyint(11)
- REPORT_CAMP_CODE — varchar(50)
- REPORT_SCORE — varchar(10)
- REPORT_STATUS — tinyint(3) — 승인, 반려(늘어날 수 있음)
- REPORT_CONTENT — text
- REPORT_REJECT_REASON — text
- REPORT_ADMIN_ID — varchar(50)
- REPORT_REJECT_DT — int(11) — timestamp
- REPORT_CREATE_DT — int(11) — timestamp
- REPORT_CREATE_IP — varchar(25)
- REPORT_MODIFY_DT — int(11) — timestamp
- REPORT_MODIFY_ID — varchar(100)
- REPORT_MODIFY_IP — varchar(25)
- REPORT_DEL_DT — int(11) — timestamp
- REPORT_DEL_ID — varchar(100)
- REPORT_DEL_IP — varchar(25)
- REPORT_DEL_YN — enum — Y,N
SERVICE_NOTICE_TBL
- SN_IDX — int — Primary key — NOT NULL
- SN_TYPE — tinyint(11) — 1 : B2C 2 : B2B
- SN_VIEW_YN — enum — Y, N
- SN_TITLE — varchar(255)
- SN_CONTENT — text
- SN_WRITER_ID — varchar(100)
- SN_LINK — varchar(255)
- SN_WRITE_DT — int(11) — timestamp
- SN_WRITER_IP — varchar(25)
- SN_MODIFY_DT — int(11) — timestamp
- SN_MODIFY_ID — varchar(100)
- SN_MODIFY_IP — varchar(25)
- SN_DEL_DT — int(11)
- SN_DEL_ID — varchar(100)
- SN_DEL_IP — varchar(25)
- SN_DEL_YN — enum — Y,N
SET_PRICE_TBL
- SP_IDX — int(11) — Primary key — NOT NULL
- CD_INDEX — int(11) — Foreign key → CATEGORY_DEPTH_TBL.CD_INDEX — NOT NULL
- SP_MIN_PRICE — int(11)
- SP_MAX_PRICE — int(11)
- SP_MAX_NON_PRICE — int(11)
- SP_UPDATE_DT — int(11)
Untitled
- Key — VARCHAR(255) — Primary key — NOT NULL