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 — 지역이름