SMU

Tables (7)

HEAD_INFO (Untitled2)

  • HEAD_CODE (소속본부코드) — Primary key — NOT NULL
  • HEAD_NAME (소속본부명)

LEVEL_INFO (Untitled3)

  • LEVEL_CODE (레벨코드) — Primary key — NOT NULL
  • LEVEL_NAME (레벨명)

MEMBER_CALINFO (Untitled7)

  • MEMBER_NO (고객번호) — Foreign key → MEMBER_INFO.MEMBER_NO — NOT NULL
  • PAY_CODE (페이코드) — Foreign key → MEMBER_INFO.PAY_CODE — NOT NULL
  • MEMBER_SALES (매출액)
  • SALES_DATE (매출기간)
  • MEMBER_CALCULATE (정산액)
  • CACLUALTE_SUM (정산합계)

MEMBER_INFO (Untitled)

  • MEMBER_NO (고객번호) — Primary key — NOT NULL
  • HEAD_CODE (소속본부코드) — Foreign key → HEAD_INFO.HEAD_CODE — NOT NULL
  • LEVEL_CODE (레벨코드) — Foreign key → LEVEL_INFO.LEVEL_CODE — NOT NULL
  • USER_NO (등록자) — Foreign key → USER_INFO.USER_NO — NOT NULL
  • PAY_CODE (페이코드) — Foreign key → PAY_INFO.PAY_CODE — NOT NULL
  • MEMBER_NAME (이름)
  • MEMBER_COMNAME (가맹점명)
  • PHONE_NUM (휴대폰번호)
  • MEMBER_ADDRESS (주소)
  • MEMBER_RESIDENT (주민등록번호)
  • MEMBER_ACCOUNT (계좌번호)
  • MEMBER_BANK (은행)
  • REGI_DATE (등록날짜)

PAY_INFO (Untitled6)

  • PAY_CODE (페이코드) — Primary key — NOT NULL
  • PAY_NAME (페이명)

ROLE_INFO (Untitled5)

  • USER_ROLE (권한코드) — Primary key — NOT NULL
  • USER_ROLENAME (권한명)

USER_INFO (Untitled4)

  • USER_NO (사용자번호) — Primary key — NOT NULL
  • USER_ROLE (권한코드) — Foreign key → ROLE_INFO.USER_ROLE — NOT NULL
  • USER_ID (아이디)
  • USER_PW (비밀번호)
  • USER_NAME (유저명)