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