TEMP

테이블 (6)

BOARD_PHOTO (사진게시판)

  • Key (게시글번호) — 기본 키 — NOT NULL
  • Field (내용)

Board (일반게시판)

  • BOARD_NO (번호) — NUMBER — 기본 키 — NOT NULL
  • USER_NO (회원번호) — NUMBER — 외래 키 → MEMBER.USER_NO
  • BOARD_TITLE (글제목) — VARCHAR2
  • BOARD_WRITER (작성자) — VARCHAR2
  • BOARD_CONTENT (Field) — VARCHAR2
  • Field2

LIKE (좋아요)

  • USER_NO (회원번호) — NUMBER — 외래 키 → MEMBER.USER_NO
  • Key (게시글번호) — 외래 키 → BOARD_PHOTO.Key — NOT NULL

MEMBER (회원정보)

  • USER_NO (회원번호) — NUMBER — 기본 키
  • USER_ID (회원아이디) — VARCHAR2(30) — NOT NULL
  • USER_PWD (회원비밀번호) — VARCHAR2(100) — NOT NULL
  • USER_NAME — VARCHAR2(15) — NOT NULL
  • PHONE — VARCHAR2(13)
  • EMAIL — VARCHAR2(100)
  • ADDRESS — VARCHAR2(100)
  • INTEREST — VARCHAR2(100)
  • ENROLL_DATE — DATE
  • MODIFY_DATE — DATE
  • STATUS — VARCHAR2(1)

NOTICE (공지사항)

  • BOARD_NO (번호) — NUMBER — 기본 키 — NOT NULL
  • BOARD_TITLE (글제목) — VARCHAR2
  • BOARD_CONTENT (글내용) — VARCHAR2
  • CREATE_DATE (작성일) — DATE
  • USER_NO (회원번호2) — NUMBER
  • USER_NO (회원번호) — NUMBER — 외래 키 → MEMBER.USER_NO

회원정보2

  • 회원번호 — NUMBER
  • 회원아이디 — VARCHAR2(30) — NOT NULL
  • 회원비밀번호 — VARCHAR2(100) — NOT NULL
  • USER_NAME — VARCHAR2(15) — NOT NULL
  • PHONE — VARCHAR2(13)
  • EMAIL — VARCHAR2(100)
  • ADDRESS — VARCHAR2(100)
  • INTEREST — VARCHAR2(100)
  • ENROLL_DATE — DATE
  • MODIFY_DATE — DATE
  • STATUS — VARCHAR2(1)