habit

Tables (9)

hAttendance (출석체크)

  • b_writeDate (작성일) — not null — Primary key — NOT NULL
  • m_num (멤버 번호) — not null — Foreign key → hMember.m_num — NOT NULL
  • c_num (카테고리 번호) — not null — Foreign key → hCategory.c_num — NOT NULL

hAuth (역할)

  • m_num (멤버 번호) — not null — Foreign key → hMember.m_num — NOT NULL
  • auth (역할) — not null

hBoard (게시판)

  • b_num (게시판 번호) — not null — Primary key — NOT NULL
  • c_num (카테고리 번호) — not null — Foreign key → hCategory.c_num — NOT NULL
  • m_num (멤버 번호) — not null — Foreign key → hMember.m_num — NOT NULL
  • b_title (제목) — not null
  • b_writeDate (작성일) — not null
  • b_updateDate (수정일) — not null
  • b_content (내용) — not null
  • b_readcount (조회수) — not null

hBoardAttach (게시판 첨부파일)

  • ba_uuid (게시판첨부파일 식별자) — notnull — Primary key — NOT NULL
  • b_num (게시판 번호) — not null — Foreign key → hBoard.b_num — NOT NULL
  • ba_uploadPath (경로) — not null
  • ba_fileName (이름) — not null
  • ba_filetype (타입) — not null

hCategory (카테고리)

  • c_num (카테고리 번호) — not null — Primary key — NOT NULL
  • c_name (카테고리명) — not null

hLike (좋아요)

  • m_num (멤버 번호) — not null — Foreign key → hMember.m_num — NOT NULL
  • b_num (게시판 번호) — not null — Foreign key → hBoard.b_num — NOT NULL

hMember (멤버)

  • m_num (멤버 번호) — not null — Primary key — NOT NULL
  • m_name (이름) — not null
  • m_pw (비밀번호) — not null
  • m_rank (레벨) — not null
  • m_mail (이메일) — not null

hMemberAttach (멤버프로필사진)

  • ma_uuid (프로필사진 식별자) — notnull — Primary key — NOT NULL
  • m_num (멤버 번호) — not null — Foreign key → hMember.m_num — NOT NULL
  • ma_uploadPath (경로) — not null
  • ma_fileName (이름) — notnull

hReply (댓글)

  • r_num (댓글 번호) — not null — Primary key — NOT NULL
  • m_num (멤버 번호) — not null — Foreign key → hMember.m_num — NOT NULL
  • b_num (게시판 번호) — not null — Foreign key → hBoard.b_num — NOT NULL
  • r_writeDate (작성일) — not null
  • r_content (내용) — not null