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