BoardProjectTest

Tables (7)

Board (BOARD)

  • Board Number (BOARD_NO) — NUMBER — Primary key — NOT NULL — Board Number (PK)
  • Board Title (BOARD_TITLE) — NVARCHAR2(100) — NOT NULL — Board Title
  • Board Content (BOARD_CONTENT) — NVARCHAR2(4000) — NOT NULL — Board Content
  • created date (BOARD_CREATED_DATE) — DATE — NOT NULL — created date
  • updated date (BOARD_UPDATE_DATE) — DATE — updated date
  • views (READ_COUNT) — NUMBER — NOT NULL — views
  • deleted (BOARD_DEL_FL) — CHAR(1) — NOT NULL — deleted(Y/N)
  • 회원번호 (MEMBER_NO) — NUMBER — Foreign key → Member.회원번호 — NOT NULL — 회원번호 (FK)
  • Board Code (BOARD_CODE) — NUMBER — Foreign key → Board Type.Board Code — NOT NULL — Board Code (FK)

Board Type (BOARD_TYPE)

  • Board Code (BOARD_CODE) — NUMBER — Primary key — NOT NULL — Board Code (PK)
  • Board Name (BOARD_NAME) — NVARCHAR2(100) — NOT NULL — Board Type

Like (BOARD_LIKE)

  • 회원번호 (MEMBER_NO) — NUMBER — Foreign key → Member.회원번호 — NOT NULL — 회원번호 (PK)
  • Board Number (BOARD_NO) — NUMBER — Foreign key → Board.Board Number — NOT NULL — Board Number

Member (MEMBER)

  • 회원번호 (MEMBER_NO) — NUMBER — Primary key — NOT NULL — 회원번호 (PK)
  • 회원이메일 (MEMBER_EMAIL) — VARCHAR2(50) — NOT NULL — 회원이메일
  • 회원비밀번호 (MEMBER_PW) — VARCHAR2(100) — NOT NULL — 회원비밀번호
  • 회원닉네임 (MEMBER_NICKNAME) — VARCHAR2(100) — NOT NULL — 회원닉네임
  • 회원전화번호 (MEMBER_TEL) — CHAR(11) — NOT NULL — 회원전화번호
  • 회원주소 (MEMBER_ADDRESS) — VARCHAR2(200) — 회원주소
  • 프로필이미지 (PROFILE_IMG) — VARCHAR2(300) — 프로필이미지
  • 회원가입일 (ENROLL_DATE) — DATE — NOT NULL — 가입일
  • 회원탈퇴여부 (MEMBER_DEL_FL) — CHAR(1) — NOT NULL — 탈퇴여부(Y/N)
  • 회원권한 (AUTHORITY) — NUMBER — NOT NULL — 권한(1 일반 2 관리자)

Upload File (UPLOAD_FILE)

  • File No (FILE_NO) — NUMBER — Primary key — NOT NULL — File No (PK)
  • File path (FILE_PATH) — VARCHAR2(500) — NOT NULL — File path
  • File original Name (FILE_ORIGINAL_NAME) — VARHCHAR2(300) — NOT NULL — Original Name
  • File rename (FILE_RENAME) — VARCHAR2(100) — NOT NULL — File rename
  • Upload date (FILE_UPLOAD_DATE) — DATE — NOT NULL — Upload date
  • 회원번호 (MEMBER_NO) — NUMBER — Foreign key → Member.회원번호 — NOT NULL — 회원번호 (FK)

board comment (COMMENT)

  • comment number (COMMENT_NO) — NUMBER — Primary key — NOT NULL — comment number (PK)
  • comment content (COMMENT_CONTENT) — VARCHAR2(500) — NOT NULL — comment content
  • comment created date (COMMENT_CREATE_DATE) — DATE — NOT NULL — comment created Date
  • comment deleted (COMMENT_DEL_FL) — CHAR(1) — NOT NULL — comment deleted
  • Board Number (BOARD_NO) — NUMBER — Foreign key → Board.Board Number — NOT NULL — Board Number (FK)
  • 회원번호 (MEMBER_NO) — NUMBER — Foreign key → Member.회원번호 — NOT NULL — 회원번호 (FK)
  • comment number (PARENT_COMMENT_NO) — NUMBER — Foreign key → board comment.comment number — NOT NULL — parent comment number (FK)

board img (BOARD_IMG)

  • image number (IMG_NO) — NUMBER — Primary key — NOT NULL — image number
  • img path (IMG_PATH) — VARCHAR2(200) — NOT NULL — image path
  • img origina name (IMG_ORIGINAL_NAME) — NVARCHAR2(100) — NOT NULL — image original name
  • img rename (IMG_RENAME) — NVARCHAR2(100) — NOT NULL — image rename
  • img order (IMG_ORDER) — NUMBER — image order
  • Board Number (BOARD_NO) — NUMBER — Foreign key → Board.Board Number — NOT NULL — Board Number (FK)