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 (유저명)