supporti_v2
Tables (23)
ACCOUNT_CONTENT
- ACCOUNT_CONTENT_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- BANK_ACCOUNT_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → BANK_ACCOUNT.BANK_ACCOUNT_IDENTIFICATION_CODE — NOT NULL
- EXCEPTED_YN — VARCHAR(255) — 'Y', 'N'
- trDt — VARCHAR(255)
- trTm — VARCHAR(255)
- inAmt — VARCHAR(255)
- outAmt — VARCHAR(255)
- balance — VARCHAR(255)
- trBr — VARCHAR(255)
- trNm — VARCHAR(255)
- trTp — VARCHAR(255)
ADMIN_MEMBER
- ADMIN_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- USER_NAME — VARCHAR(255)
- PASSWORD — VARCHAR(255)
- FULL_NAME — VARCHAR(255)
- PHONE_NUMBER — VARCHAR(255)
- IS_SUPER — VARCHAR(255)
APP_MEMBER
- APP_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- USER_TYPE — VARCHAR(255) — 'GENERAL', 'BUSINESS'
- USER_NAME — VARCHAR(255)
- PASSWORD — VARCHAR(255)
- FULL_NAME — VARCHAR(255)
- PHONE_NUMBER — VARCHAR(255)
- ALIMTALK_YN — VARCHAR(255) — 'Y', 'N'
- SNS_USER_ID — VARCHAR(255) — 소셜로그인 대상자(카카오, 네이버, 구글)
BANK_ACCOUNT
- BANK_ACCOUNT_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- APP_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → APP_MEMBER.APP_MEMBER_IDENTIFICATION_CODE — NOT NULL
- BANK_CODE — VARCHAR(255)
- LOGIN_METHOD — VARCHAR(255)
- ACCOUNT_NUMBER — VARCHAR(255)
- ACCOUNT_HOLDER — VARCHAR(255)
- ACCOUNT_NICKNAME — VARCHAR(255)
- START_DATE — VARCHAR(255)
- ACCOUNT_INFO — VARCHAR(255) — {userId, userPw, signCert, signPri, signPw, accNo, accPw}
BURN_RATE_CONDITION
- BURN_RATE_CONDITION_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- APP_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → APP_MEMBER.APP_MEMBER_IDENTIFICATION_CODE — NOT NULL
- START_DATE — VARCHAR(255) — BurnRate 평균 개월
- END_DATE — VARCHAR(255) — BurnRate 기준 시간
BUSINESS
- BUSINESS_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- APP_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → APP_MEMBER.APP_MEMBER_IDENTIFICATION_CODE — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field7 — VARCHAR(255)
- Field8 — VARCHAR(255)
- Field9 — VARCHAR(255)
BUSINESS_HISTORY
- BUSINESS_HISTORY_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- BUSINESS_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → BUSINESS.BUSINESS_IDENTIFICATION_CODE — NOT NULL
- NUM_OF_EMPLOYEES — VARCHAR(255)
- INVEST_ROUND — VARCHAR(255) — nullable
CONSULTING
- CONSULTING_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- PARTNER_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → PARTNER_MEMBER.PARTNER_MEMBER_IDENTIFICATION_CODE — NOT NULL
- STATUS — ENUM — 예약마감, 비공개 등
- CONSULTING_TITLE — VARCHAR(255)
- POSSIBLE_TIME — VARCHAR(255) — {0: ,,, 1: ,,}
- EXCEPT_DATE_LIST — VARCHAR(255) — 'y-m-d', 'y-m-d
- , — `INTERVAL` — 분단위
- PRICE — VARCHAR(255)
- IMAGE_LIST — VARCHAR(255)
- QUESTION_LIST — VARCHAR(255)
CONSULTING_RESERVATION
- CONSULTING_RESERVATION_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- CONSULTING_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → CONSULTING.CONSULTING_IDENTIFICATION_CODE — NOT NULL
- APP_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → APP_MEMBER.APP_MEMBER_IDENTIFICATION_CODE — NOT NULL
- CANCELED_YN — VARCHAR(255) — 'Y', 'N'
- CONSULTING_NUMBER — VARCHAR(255)
- RESERVATION_DATE — VARCHAR(255)
- RESERVATION_TIME — VARCHAR(255)
- STATUS — VARCHAR(255)
- USER_NOTE — VARCHAR(255)
- CONSULTING_NOTE — VARCHAR(255)
- ANSWER_LIST — VARCHAR(255)
EVENT
- EVENT_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- ADMIN_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → ADMIN_MEMBER.ADMIN_MEMBER_IDENTIFICATION_CODE — NOT NULL
- TITLE — VARCHAR(255)
- CONTENT — VARCHAR(255)
- IMAGE_LIST — VARCHAR(255)
FAQ_BOARD_CONTENT
- FAQ_BOARD_CONTENT_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- ADMIN_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → ADMIN_MEMBER.ADMIN_MEMBER_IDENTIFICATION_CODE — NOT NULL
- TITLE — VARCHAR(255)
- CONTENT — VARCHAR(255)
- IMAGE_LIST — VARCHAR(255)
FINANCE
- FINANCE_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- BUSINESS_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → BUSINESS.BUSINESS_IDENTIFICATION_CODE — NOT NULL
- YEAR — VARCHAR(255)
- PROFIT — VARCHAR(255)
- OPERATING_PROFIT — VARCHAR(255)
- NET_INCOME — VARCHAR(255)
- FINANCIAL_COST — VARCHAR(255)
- DEPRECIATION — VARCHAR(255)
- DEPRECIATION_AND_AMORTIZATION — VARCHAR(255)
- AMORTIZATION — VARCHAR(255)
- TOTAL_ASSETS — VARCHAR(255)
- Field9 — VARCHAR(255)
- TOTAL_EQUITY — VARCHAR(255)
- CAPITAL_STOCK — VARCHAR(255)
- Field12 — VARCHAR(255)
- Field13 — VARCHAR(255)
- Field14 — VARCHAR(255)
- Field15 — VARCHAR(255)
- Field16 — VARCHAR(255)
- Field17 — VARCHAR(255)
- Field18 — VARCHAR(255)
- Field19 — VARCHAR(255)
- Field20 — VARCHAR(255)
- Field21 — VARCHAR(255)
- Field22 — VARCHAR(255)
- Field23 — VARCHAR(255)
- Field24 — VARCHAR(255)
- Field25 — VARCHAR(255)
- Field26 — VARCHAR(255)
NOTICE_BOARD_CONTENT
- NOTICE_BOARD_CONTENT_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- ADMIN_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → ADMIN_MEMBER.ADMIN_MEMBER_IDENTIFICATION_CODE — NOT NULL
- TITLE — VARCHAR(255)
- CONTENT — VARCHAR(255)
- IMAGE_LIST — VARCHAR(255)
- IS_TOP_FIXED — VARCHAR(255)
PARTNER_MEMBER
- PARTNER_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- USER_NAME — VARCHAR(255)
- PASSWORD — VARCHAR(255)
- FULL_NAME — VARCHAR(255)
- PHONE_NUMBER — VARCHAR(255)
- PARTNER_TYPE — VARCHAR(255) — CONSULTANT
PAYMENT_HISTORY
- PAYMENT_HISTORY_IDNETIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- APP_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → APP_MEMBER.APP_MEMBER_IDENTIFICATION_CODE — NOT NULL
- ORDER_ID — VARCHAR(255)
- PAY_METHOD — VARCHAR(255)
- CONTENT — VARCHAR(255)
- APPROVED_DATE — VARCHAR(255)
- AMOUNT — VARCHAR(255)
- STATUS — VARCHAR(255)
PAYMENT_INFO
- PAYMENT_INFO_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- APP_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → APP_MEMBER.APP_MEMBER_IDENTIFICATION_CODE — NOT NULL
- CUSTOMER_KEY — VARCHAR(255)
- BILLING_KEY — VARCHAR(255)
POINT_HISTORY
- POINT_HISTORY_IDENTIFICATON_CODE — VARCHAR(255) — Primary key — NOT NULL
- APP_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → APP_MEMBER.APP_MEMBER_IDENTIFICATION_CODE — NOT NULL
- TYPE — ENUM — 생성, 사용
- CONTENT — VARCHAR(255)
- AMOUNT — VARCHAR(255)
QNA_BOARD_ANSWER
- QNA_BOARD_ANSWER_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- ADMIN_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → ADMIN_MEMBER.ADMIN_MEMBER_IDENTIFICATION_CODE — NOT NULL
- QNA_BOARD_QUESTION_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → QNA_BOARD_QUESTION.QNA_BOARD_QUESTION_IDENTIFICATION_CODE — NOT NULL
- TITLE — VARCHAR(255)
- CONTENT — VARCHAR(255)
QNA_BOARD_QUESTION
- QNA_BOARD_QUESTION_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → APP_MEMBER.APP_MEMBER_IDENTIFICATION_CODE — NOT NULL
- TITLE — VARCHAR(255)
- CONTENT — VARCHAR(255)
SEMINAR
- SEMINAR_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- PARTNER_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → PARTNER_MEMBER.PARTNER_MEMBER_IDENTIFICATION_CODE — NOT NULL
- STATUS — ENUM
- SEMINAR_TITLE — VARCHAR(255)
- SEMINAR_DATE — VARCHAR(255)
- IMAGE_LIST — VARCHAR(255)
- PRICE — VARCHAR(255)
- PERSONNEL — VARCHAR(255)
SEMINAR_PARTICIPATION
- SEMINAR_PARTICIPATION_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- SEMINAR_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → SEMINAR.SEMINAR_IDENTIFICATION_CODE — NOT NULL
- APP_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → APP_MEMBER.APP_MEMBER_IDENTIFICATION_CODE — NOT NULL
- CANCELED_YN — VARCHAR(255) — 'Y','N'
- BUSINESS_NAME — VARCHAR(255)
- POSITION — VARCHAR(255)
- NAME — VARCHAR(255)
- PHONE — VARCHAR(255)
- EMAIL — VARCHAR(255)
SUBSCRIPTION
- SUBSCRIPTION_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- ADMIN_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → ADMIN_MEMBER.ADMIN_MEMBER_IDENTIFICATION_CODE — NOT NULL
- ORDER — VARCHAR(255)
- ACTIVATED_YN — VARCHAR(255) — 'Y', 'N'
- NAME — VARCHAR(255)
- DESCRIPTION — VARCHAR(255)
- PRICE — VARCHAR(255)
- DISCOUNT_PRICE — VARCHAR(255)
- DETAIL — {}
- POINT_AMOUNT — VARCHAR(255) — 실제 지급되는 포인트
USER_SUBSCRIPTION
- USER_SUBSCRIPTION_IDENTIFICATION_CODE — VARCHAR(255) — Primary key — NOT NULL
- SUBSCRIPTION_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → SUBSCRIPTION.SUBSCRIPTION_IDENTIFICATION_CODE — NOT NULL
- APP_MEMBER_IDENTIFICATION_CODE — VARCHAR(255) — Foreign key → APP_MEMBER.APP_MEMBER_IDENTIFICATION_CODE — NOT NULL
- SUBSCRIPTION_NUMBER — VARCHAR(255)
- AMOUNT — VARCHAR(255) — POINT_AMOUNT
- NEXT_BILLING_DATE — VARCHAR(255)
- INTERVAL — VARCHAR(255) — MONTHLY, YEARLY
- CANCELED_YN — VARCHAR(255) — 'Y', 'N'