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)