1234
Tables (7)
BOARD
- BOARD_NO — NUMBER — Primary key — NOT NULL — 게시글
- BOARD_TITLE — NVARCHAR2(100) — NOT NULL — 게시글
- BOARD_CONTENT — VARCHAR2(4000) — NOT NULL — 게시글
- BOARD_WRITE_DATE — DATE — NOT NULL — 게시글
- BOARD_UPDATE_DATE — DATE — 게시글
- READ_COUNT — NUMBER — NOT NULL — 조회수
- BOARD_DEL_FL — CHAR(1) — NOT NULL — 게시글
- BOARD_CODE — NUMBER — Foreign key → BOARD_TYPE.BOARD_CODE — NOT NULL — 게시판
- MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL — 작성한
BOARD_IMG
- IMG_NO — NUMBER — Primary key — NOT NULL — 이미지
- IMG_PATH — VARCHAR2(200) — NOT NULL — 이미지
- IMG_ORIGINAL_NAME — NVARCHAR2(50) — NOT NULL — 이미지
- IMG_RENAME — NVARCHAR2(50) — NOT NULL — 이미지
- IMG_ORDER — NUMBER — 이미지
- BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL — 게시글
BOARD_LIKE
- MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL — 화원
- BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL — 게시글
BOARD_TYPE
- BOARD_CODE — NUMBER — Primary key — NOT NULL — 게시판
- BOARD_NAME — NVARCHAR2(20) — NOT NULL — 게시판명
COMMENT
- COMMENT_NO — NUMBER — Primary key — NOT NULL — 댓글
- COMMENT_CONTENT — VARCHAR2(4000) — NOT NULL — 댓글
- COMMENT_WRITH_DATE — DATE — NOT NULL — 댓글
- COMMENT_DEL_FL — CHAR(1) — NOT NULL — 댓글
- BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL — 게시글
- MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL — 화원
- PARENT_COMMENT_NO — NUMBER — Foreign key → COMMENT.COMMENT_NO — 부모
MEMBER
- MEMBER_NO — NUMBER — Primary key — NOT NULL — 화원
- MEMBER_EMAIL — NVARCHAR2(50) — NOT NULL — 회원
- MEMBER_PW — NVARCHAR2(100) — NOT NULL — 회원
- MEMBER_NICKNAME — NVARCHAR2(10) — 회원
- MEMBER_TEL — CHAR(11) — 회원
- MEMBER_ADDRESS — NVARCHAR2(300) — 회원
- PROFILE_IMG — VARCHAR2(300) — 프로필
- ENROLL_DATE — DATE — NOT NULL — 회원
- MEMBER_DEL_FL — CHAR(1) — NOT NULL — 탈퇴
- AUTHORITY — NUMBER — NOT NULL — 권한(1:일반
UPLOAD_FILE
- FILE_NO — NUMBER — Primary key — NOT NULL — 파일
- FILE_PATH — VARCHAR2(500) — NOT NULL — 파일
- FILE_ORIGINAL_NAME — VARCHAR2(300) — NOT NULL — 파일
- FILE_RENAME — VAHRCHAR(100) — NOT NULL — 파일
- FILE_UPLOAD_DATE — DATE — NOT NULL — 업로드
- MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL — 업로드한