0
Tables (6)
SH_GRADE
- MB_LEVEL — VARCHAR2(30 BYTE)
- MB_GR_NAME — VARCHAR2(30 BYTE)
SH_GROUP
- GROUP_ID — NUMBER
- MB_ID — VARCHAR2(30 BYTE)
- GROUP_PPL_NUMBER — NUMBER
- GROUP_PAYDATE — NUMBER
- GROUP_ACCOUNT_INFO — VARCHAR2(60 BYTE)
- GROUP_SHARE_ID — VARCHAR2(30 BYTE)
- GROUP_SHARE_PASSWORD — VARCHAR2(30 BYTE)
- GROUP_DATE — DATE
- GROUP_AUTO_DATE — DATE
- SER_CODE — VARCHAR2(30 BYTE) — Foreign key → SH_SER_CODE.SER_CODE
- GROUP_PPL_WISH_NUMBER — NUMBER
- GROUP_LAST_DAY — DATE
SH_NOTICE
- NOTICE_NO — NUMBER
- NOTICE_TITLE — VARCHAR2(250 BYTE)
- NOTICE_CONTENT — VARCHAR2(1000 BYTE)
- NOTICE_DATE — DATE
- NOTICE_VIEW — NUMBER
- NOTICE_TYPE — VARCHAR2(30 BYTE)
- MB_ID — VARCHAR2(30 BYTE)
- NOTICE_DELETE — DATE
- NOTICE_TOTAL_POSTS — NUMBER
- NOTICE_CATEGORY — NUMBER
- NOTICE_KEYWORD — VARCHAR2(30 BYTE)
SH_REPORT
- REPORT_IDX — NUMBER
- MB_ID — VARCHAR2(30 BYTE)
- GROUP_IDX — NUMBER — Foreign key → SH_GROUP.GROUP_ID
- REPORT_CONTENT — VARCHAR2(1000 CHAR)
- REPORT_DATE — DATE
- REPORT_REPLY — VARCHAR2(1000 CHAR)
- REPORT_CLEAR — NUMBER
- REPORT_TITLE — VARCHAR2(250 BYTE)
SH_SER_CODE
- SER_CODE — VARCHAR2(30 BYTE)
- SER_NAME — VARCHAR2(60 BYTE)
- SER_MAX_NUM — NUMBER
- SER_PRICE — VARCHAR2(60 BYTE)
- SER_PER_DAY — NUMBER
TB_MEMBER
- USER_ID — VARCHAR2(30 CHAR)
- PASSWORD — VARCHAR2(60 CHAR)
- EMAIL — VARCHAR2(50 CHAR)
- GRADE — CHAR(4 CHAR)
- TELL — VARCHAR2(15 CHAR)
- REG_DATE — DATE
- RENTABLE_DATE — DATE
- IS_LEAVE — NUMBER