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