XI_CONCIERGE

Tables (6)

CCG_API

  • SEQ — INT — Primary key — NOT NULL
  • SEQ (SERVICE_ID) — INT — Foreign key → CCG_SERVICE.SEQ — NOT NULL
  • SEQ (MEMBER_ID) — INT — Foreign key → CCG_SERVICE.SEQ — NOT NULL
  • MEMBER_SEQ — VARCHAR(50)
  • APP_TYPE — VARCHAR(50)
  • API_KEY — VARCHAR(50)
  • CLIENT_URL_SCHEME — VARCHAR(255)
  • CLIENT_IP — VARCHAR(15)
  • CLIENT_HOST — VARCHAR(255)
  • STATUS — ENUM
  • UPDATED — DATETIME
  • REG_DATE — DATETIME
  • DELETED_DATE — DATETIME
  • DATA_FORMAT — VARCHAR(2048)
  • METHOD — VARCHAR(10)

CCG_API_HISTORY

  • SEQ — INT — Primary key — NOT NULL
  • SEQ (API_ID) — INT — Foreign key → CCG_API.SEQ — NOT NULL
  • SEQ (SERVICE_ID) — INT — Foreign key → CCG_API.SEQ — NOT NULL
  • SEQ (MEMBER_ID) — INT — Foreign key → CCG_API.SEQ — NOT NULL
  • APP_TYPE — ENUM
  • API_KEY — VARCHAR(50)
  • CLIENT_URL_SCHEME — VARCHAR(255)
  • CLIENT_IP — VARCHAR(15)
  • CLIENT_HOST — VARCHAR(255)
  • STATUS — ENUM
  • UPDATED — DATETIME
  • REGDATE — DATETIME
  • DELETED_DATE — DATETIME

CCG_MEMBERS

  • SEQ — INT — Primary key — NOT NULL
  • REG_DATE — DATETIME
  • UPDATE_DATE (APP_TYPE) — DATETIME
  • LAST_IN_DATE — DATETIME
  • EMAIL1 (1) — VARCHAR(128)
  • PWD — VARCHAR(2048)
  • NAME — NVARCHAR(32)
  • ADDR_DO — NVARCHAR(16)
  • ADDR_GU — NVARCHAR(16)
  • PHONE — VARCHAR(11)
  • APT_SEQ — INT
  • APT_DONG — NVARCHAR(16)
  • APT_HO — NVARCHAR(16)
  • IS_AD — VARCHAR(1)
  • IS_AUTH — VARCHAR(1)
  • IS_LOCK — VARCHAR(1)
  • FAIL_CNT — INT
  • LAST_LOGIN_IP — VARCHAR(26)
  • kakao_login — VARCHAR(1)
  • push_yn — VARCHAR(1)
  • local_pushyn — VARCHAR(1)
  • ADDR_DONG — NVARCHAR(20)
  • ADDR_DDETAIL — NVARCHAR(50)
  • ADDR_DETAIL — NVARCHAR(50)
  • is_phone_auth — VARCHAR(1)
  • ADDR_ROAD — NVARCHAR(300)
  • IS_SMS — VARCHAR(1)
  • CHILD_YN — VARCHAR(1)
  • GS_SERVICE_YN — VARCHAR(1)
  • PERSON_YN — VARCHAR(1)
  • BUSINESS_YN — VARCHAR(1)
  • MARKETING_YN — VARCHAR(1)
  • SEX — VARCHAR(1)
  • BIRTH_DATE — NVARCHAR(10)
  • REAL_PROPERTY_YN — VARCHAR(1)
  • PHONE_AUTH_YN — VARCHAR(1)
  • BUSINESS_NUMBER — VARCHAR(13)
  • BUSINESS_NAME — NVARCHAR(128)
  • UNIQUE_ID — VARCHAR(256)
  • BARCODE_ID (Field8) — VARCHAR(21)
  • MEMBER_TYPE — VARCHAR(1)
  • BUSINESS_AUTH_YN — VARCHAR(1)
  • PERSON_AUTH_YN — VARCHAR(1)
  • CI — VARCHAR(88)
  • BUSINESS_AUTH_DATE — DATETIME
  • PERSON_AUTH_DATE — DATETIME
  • LOCATION_YN — VARCHAR(1)
  • EMAIL — VARCHAR(128)

CCG_SERVICE

  • SEQ — INT — Primary key — NOT NULL
  • SEQ (MEMBE_ID) — INT — Foreign key → CCG_MEMBERS.SEQ — NOT NULL
  • NAME — NVARCHAR(50)
  • EMAIL — VARCHAR(128)
  • SVCS_PROVIDER — NVARCHAR(25)
  • SVCS_CATEGORY — NVARCHAR(16)
  • SVCS_AREA — NVARCHAR(16)
  • PHONE — NVARCHAR(25)
  • SERVICE_COST — INT
  • PAY_METHOD — NVARCHAR(32)
  • OPEN_TIME — NVARCHAR(50)
  • HOWTO_USE — NVARCHAR(2056)
  • IS_PARKING — VARCHAR(1)
  • DISCOUNT — INT
  • SUPPLY — NVARCHAR(128)
  • HOMEPAGE — VARCHAR(256)
  • SNS — NVARCHAR(128)
  • NOTICE — NVARCHAR(258)
  • COMMENT — NVARCHAR(128)
  • BIZ_CATEGORY — NVARCHAR(28)
  • BIZ_REG_NUMBER — VARCHAR(16)
  • BIZ_TYPE — NVARCHAR(16)
  • LEGAL_AGE — INT
  • DESCRIPTION — NVARCHAR(2048)
  • REG_DATE — DATETIME
  • UPDATE — DATETIME

INVOICE

  • SEQ — INT — Primary key — NOT NULL
  • SEQ (INVOICE_ID) — INT — Foreign key → ORDER.SEQ — NOT NULL
  • SEQ (API_ID) — INT — Foreign key → ORDER.SEQ — NOT NULL
  • SEQ (SEQ2) — INT — Foreign key → ORDER.SEQ — NOT NULL
  • SEQ (MEMBE_ID) — INT — Foreign key → ORDER.SEQ — NOT NULL
  • SEQ (SEQ22) — INT — Foreign key → ORDER.SEQ — NOT NULL
  • SERVICE_NAME — NVARCHAR(50)
  • SERVICE_COST — INT
  • SERVICE_STATE — VARCHAR(5)
  • PAYMENT_TYPE — VARCHAR(15)
  • MEMO — NVARCHAR(1208)
  • REG_DATE — DATETIME
  • Field2 — VARCHAR(50

ORDER

  • SEQ — INT — Primary key — NOT NULL
  • SEQ (API_ID) — INT — Foreign key → CCG_API.SEQ — NOT NULL
  • SEQ (SERVICE_ID) — INT — Foreign key → CCG_SERVICE.SEQ — NOT NULL
  • SEQ (MEMBE_ID) — INT — Foreign key → CCG_SERVICE.SEQ — NOT NULL
  • SEQ (MEMBE_ID2) — INT — Foreign key → CCG_MEMBERS.SEQ — NOT NULL
  • TOKEN — VARCHAR(128)
  • SERVICE_STATE — VARCHAR(5)
  • PAYMENT_TYPE — VARCHAR(15)
  • MEMO — NVARCHAR(1208)
  • ORDER_DATE — DATETIME
  • SERVICE_NAME — NVARCHAR(50)
  • SERVICE_COST — INT