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 — 업로드한