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