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'