MINIPROJECT_2023.01.30
Tables (3)
CATEGOEY_TBL (Untitled)
- CATEGORY_TITLE (카테고리 이름) — Primary key — NOT NULL
- CATEGORY_NO (카테고리 번호) — NUMBER
MEMBER_TBL
- MEMBER_ID (아이디) — VARCHAR2 — Primary key — NOT NULL
- POST_NO (게시글 번호) — NUMBER — Foreign key → POST_TBL.POST_NO — NOT NULL
- MEMBER_PW (비밀번호) — VARCHAR2
- MEMBER_NICKNAME (닉네임) — VARCHAR2
- MEMBER_EMAIL (이메일) — VARCHAR2
- MEMBER_DATE (가입날짜) — TIMESTAMP — NOT NULL
POST_TBL (게시글)
- POST_NO (게시글 번호) — NUMBER — Primary key — NOT NULL
- POST_SUBJECT (제목) — VARCHAR2
- POST_CONTENT (내용) — VARCHAR2
- MEMBER_NICKNAME (닉네임) — VARCHAR2
- POST_DATE (작성 날짜) — TIMESTAMP
- POST_COUNT (조회수) — NUMBER
- POST_CATEGORY (카테고리) — VARCHAR2