job

Tables (6)

APPLE_BOARD

  • APPLE_BOARD_NO — NUMBER — Primary key — NOT NULL — 게시글번호
  • APPLE_BOARD_TITLE — VARCHAR2(255) — NOT NULL — 제목
  • APPLE_BOARD_CONTENT — CLOB — NOT NULL — 내용
  • APPLE_BOARD_REG_DATE — DATE — NOT NULL — 작성일자
  • APPLE_BOARD_DEL_FL — CHAR(1) — NOT NULL — N등록, T 임시저장,Y삭제
  • APPLE_BOARD_WRITER (APPLE_MEMBER_NO2) — NUMBER — Foreign key → APPLE_MEMBER.APPLE_MEMBER_NO — NOT NULL — 글쓴이
  • APPLE_BOARD_CATEGORY_NO — NUMBER — Foreign key → APPLE_BOARD_CATEGORY.APPLE_BOARD_CATEGORY_NO — NOT NULL — 카테고리번호

APPLE_BOARD_CATEGORY

  • APPLE_BOARD_CATEGORY_NO — NUMBER — Primary key — NOT NULL — 카테고리번호
  • APPLE_BOARD_CATEGORY_NAME — NVARCHAR2(20) — NOT NULL — 카테고리이름

APPLE_MEMBER

  • APPLE_MEMBER_NO — NUMBER — Primary key — NOT NULL — 회원번호
  • APPLE_MEMBER_PW — NVARCHR2(25) — NOT NULL — 비밀번호

COMMENT (Untitled2)

  • Key (COMMENT_NO) — NUMBER — Primary key — NOT NULL — 식별번호
  • Field (WRITER) — NVARCHAR2(12) — NOT NULL — 작성자
  • Field2 (CONTENT) — NVARCHAR2(50) — NOT NULL — 내용
  • Field3 (REG_DATE) — DATE — NOT NULL — 작성일
  • Field4 (DEL_FL) — CHAR(1) — NOT NULL — 삭제여부

VISIT (Untitled)

  • 식별자 (VISIT_NO) — VARCHAR2(6) — Primary key — NOT NULL — 방문일
  • 방문수 (VISIT_COUNT) — NUMBER — 방문자 수

WEATHER_REG

  • REG_ID — VARCHAR2(10) — Primary key — NOT NULL — 지역코드
  • REG_NAME — NVARCHAR2(10) — NOT NULL — 지역이름