SW
Tables (16)
SW_CODE (Untitled)
- GRP (Field) — VARCHAR2(20)
- ID (Field2) — VARCHAR2(64)
- NAME (Field3) — VARCHAR2(100)
SW_CODE (CopyOfUntitled)
- GRP (Field) — VARCHAR2(20)
- ID (Field2) — VARCHAR2(64)
- NAME (Field3) — VARCHAR2(100)
SW_FRANCHISE (1)
- ID (Key) — NUMBER — Primary key — NOT NULL
- 상호 (Field) — VARCHAR2(255)
- 회사명 (Field2) — VARCHAR2(255)
- 업종 (Field4) — VARCHAR2(50)
- 등록번호 (Field3) — NUMBER
- 법인번호 (Field5) — VARCHAR2(50)
- 사업자번호 (Field6) — VARCHAR2(50)
- 우편번호 (Field7) — VARCHAR2(50)
- 주소 (Field8) — VARCHAR2(255)
- 휴대전화 (Field9) — VARCHAR2(15)
SW_FRANCHISE_USER (CopyOf1)
- FRANCHISE_ID (Key) — NUMBER — Primary key — NOT NULL
- 상호 (Field) — VARCHAR2(255)
- 회사명 (Field2) — VARCHAR2(255)
- 업종 (Field4) — VARCHAR2(50)
- 등록번호 (Field3) — NUMBER
- 법인번호 (Field5) — VARCHAR2(50)
- 사업자번호 (Field6) — VARCHAR2(50)
- 우편번호 (Field7) — VARCHAR2(50)
- 주소 (Field8) — VARCHAR2(255)
- 휴대전화 (Field9) — VARCHAR2(15)
- USER_ID (Field10) — VARCHAR2(20)
- USER_PWD (Field11) — VARCHAR2(50)
- FAIL_CNT (Field12) — NUMBER
- LAST_LOGIN (Field13) — DATE
- API_KEY (Field14) — VARCHAR2(64)
SW_FRANCHISE_USER (CopyOfCopyOf1)
- FRANCHISE_ID (Key) — NUMBER — Primary key — NOT NULL
- 상호 (Field) — VARCHAR2(255)
- 회사명 (Field2) — VARCHAR2(255)
- 업종 (Field4) — VARCHAR2(50)
- 등록번호 (Field3) — NUMBER
- 법인번호 (Field5) — VARCHAR2(50)
- 사업자번호 (Field6) — VARCHAR2(50)
- 우편번호 (Field7) — VARCHAR2(50)
- 주소 (Field8) — VARCHAR2(255)
- 휴대전화 (Field9) — VARCHAR2(15)
- USER_ID (Field10) — VARCHAR2(20)
- USER_PWD (Field11) — VARCHAR2(20)
- FAIL_CNT (Field12) — NUMBER
- LAST_LOGIN (Field13) — DATE
- API_KEY (Field14) — VARCHAR2(64)
SW_PAYMENT_CODE (Untitled2)
- PAYMENT_CODE (Key) — NUMBER — Primary key — NOT NULL
- PAYMENT (Field) — VARCHAR2(20)
SW_PAYMENT_CODE (LoV)
- PAYMENT_CODE (Key) — NUMBER — Primary key — NOT NULL
- PAYMENT (Field) — VARCHAR2(20)
SW_RECEIPT_DATA (Untitled3)
- ID (Key) — VARCHAR2(255) — Primary key — NOT NULL
- CREATED (Field) — TIMESTAMP(6)
- LAST_MODIFIED (Field2) — TIMESTAMP(6)
- VERSION (Field3) — VARCHAR2(255)
- JSON_DOCUMENT (Field4) — CLOB
SW_RECEIPT_DATA (CopyOfUntitled3)
- ID (Key) — VARCHAR2(255) — Primary key — NOT NULL
- STORE_ACCOUNT_ID (Key2) — NUMBER — Foreign key → SW_STORE_ACCOUNT.ID — NOT NULL
- PAYMENT_CODE (Key22) — NUMBER — Foreign key → SW_STORE_ACCOUNT.PAYMENT_CODE — NOT NULL
- STORE_CODE (Key3) — NUMBER — Foreign key → SW_STORE_ACCOUNT.STORE_CODE — NOT NULL
- FRANCHISE_ID (Key222) — NUMBER — Foreign key → SW_STORE_ACCOUNT.FRANCHISE_ID — NOT NULL
- CREATED (Field) — TIMESTAMP(6)
- LAST_MODIFIED (Field2) — TIMESTAMP(6)
- VERSION (Field3) — VARCHAR2(255)
- JSON_DOCUMENT (Field4) — CLOB
SW_STORE_ACCOUNT (Untitled4)
- ID (Key) — NUMBER — Primary key — NOT NULL
- PAYMENT_CODE (Key2) — NUMBER — Foreign key → SW_PAYMENT_CODE.PAYMENT_CODE — NOT NULL
- STORE_CODE (Field1) — NUMBER
- PAYMENT_ID (Field3) — VARCHAR2(64)
- PAYMENT_PWD (Field4) — VARCHAR2(100)
- PAYMENT_STORE_ID (Field5) — VARCHAR2(30)
SW_STORE_ACCOUNT (CopyOfUntitled4)
- ID (Key) — NUMBER — Primary key — NOT NULL
- PAYMENT_CODE (Key2) — NUMBER — Foreign key → SW_PAYMENT_CODE.PAYMENT_CODE — NOT NULL
- STORE_CODE (Key3) — NUMBER — Foreign key → SW_STORE_USER.STORE_CODE — NOT NULL
- FRANCHISE_ID (Key22) — NUMBER — Foreign key → SW_STORE_USER.FRANCHISE_ID — NOT NULL
- PAYMENT_ID (Field3) — VARCHAR2(64)
- PAYMENT_PWD (Field4) — VARCHAR2(100)
SW_STORE_PAYMENT (Untitled5)
- STORE_CODE (Key) — NUMBER — Primary key — NOT NULL
- PAYMENT_CODE (Field) — NUMBER
- PAYMENT_ID (Field2) — VARCHAR2(30)
- PAYMENT_PWD (Field3) — VARCHAR2(30)
- PAYMENT_STORE_ID (Field4) — VARCHAR2(50)
- FRANCHISE_ID (Field5) — NUMBER
SW_STORE_USER (Untitled6)
- STORE_CODE (Key) — NUMBER — Primary key — NOT NULL
- FRANCHISE_ID (Key2) — NUMBER — Foreign key → SW_FRANCHISE_USER.FRANCHISE_ID — NOT NULL
- USER_ID (Field) — VARCHAR2(30)
- USER_PWD (Field2) — VARCHAR2(32)
- 대표자명 (Field3) — VARCHAR2(20)
- 성별 (Field4) — VARCHAR2(10)
- 생년월일 (Field5) — VARCHAR2(10)
- 가맹점명 (Field6) — VARCHAR2(50)
- 가맹점번호 (Field7) — NUMBER
- 상세주소 (Field8) — VARCHAR2(100)
- 전화번호 (Field9) — VARCHAR2(15)
- 사업자번호 (Field10) — VARCHAR2(20)
- FAIL_CNT (Field11) — NUMBER
- LAST_LOGIN (Field12) — DATE
- APPROVAL_YN (Field13) — VARCHAR2(1)
- APPROVAL_DATE (Field14) — DATE
- APPROVAL_ID (Field15) — VARCHAR2(20)
SW_STORE_USER (CopyOfUntitled6)
- STORE_CODE (Key) — NUMBER — Primary key — NOT NULL
- FRANCHISE_ID (Key2) — NUMBER — Foreign key → SW_FRANCHISE_USER.FRANCHISE_ID — NOT NULL
- 대표자명 (Field3) — VARCHAR2(20)
- 성별 (Field4) — VARCHAR2(10)
- 생년월일 (Field5) — VARCHAR2(10)
- 가맹점명 (Field6) — VARCHAR2(50)
- 가맹점번호 (Field7) — NUMBER
- 상세주소 (Field8) — VARCHAR2(100)
- 전화번호 (Field9) — VARCHAR2(15)
- 사업자번호 (Field10) — VARCHAR2(20)
- USER_ID (Field) — VARCHAR2(30)
- USER_PWD (Field2) — VARCHAR2(32)
- FAIL_CNT (Field11) — NUMBER
- LAST_LOGIN (Field12) — DATE
- APPROVAL_YN (Field13) — VARCHAR2(1)
- APPROVAL_DATE (Field14) — DATE
- APPROVAL_ID (Field15) — VARCHAR2(20)
SW_USER (Untitled7)
- USER_ID (Key) — VARCHAR2(20) — Primary key — NOT NULL
- USER_NAME (Field) — VARCHAR2(20)
- USER_PWD (Field2) — VARCHAR2(255)
- ROLE_ID (Field3) — VARCHAR2(100)
- EMAIL (Field4) — VARCHAR2(50)
- FAIL_CNT (Field5) — NUMBER
- LAST_LOGIN (Field6) — DATE
- LOCKS (Field7) — NUMBER
- CREATED (Field8) — DATE
- CREATED_BY (Field9) — VARCHAR2(20)
- UPDATED (Field10) — DATE
- UPDATED_BY (Field11) — VARCHAR2(20)
- AUTHNUM (Field12) — NUMBER
- MFA_CNT (Field13) — NUMBER
SW_USER (CopyOfUntitled7)
- USER_ID (Key) — VARCHAR2(20) — Primary key — NOT NULL
- USER_NAME (Field) — VARCHAR2(20)
- USER_PWD (Field2) — VARCHAR2(255)
- ROLE_ID (Field3) — VARCHAR2(100)
- EMAIL (Field4) — VARCHAR2(50)
- FAIL_CNT (Field5) — NUMBER
- LAST_LOGIN (Field6) — DATE
- LOCKS (Field7) — NUMBER
- CREATED (Field8) — DATE
- CREATED_BY (Field9) — VARCHAR2(20)
- UPDATED (Field10) — DATE
- UPDATED_BY (Field11) — VARCHAR2(20)
- AUTHNUM (Field12) — NUMBER
- MFA_CNT (Field13) — NUMBER