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