smhrd project2
Tables (9)
BOARD (게시글)
- BOARD_NO (게시글번호) — NUMBER — Primary key — NOT NULL
- MEMBER_ID (회원아이디) — VARCHAR2 — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- BOARD_TITLE (게시글제목) — VARCHAR2
- BOARD_CONTENT (게시글내용) — VARCHAR2
- WRITE_DATE (작성일자) — DATE
- FILE_NAME (파일이름) — VARCHAR2
- WRITER (작성자 닉네임) — VARCHAR2
- GOOD (추천수) — NUMBER
- BAD (싫어요 수) — NUMBER
COMMONCODE (공통코드)
- CONE_ID (코드ID) — VARCHAR2 — Primary key — NOT NULL
- CODE_NM (코드이름) — VARCHAR2
- USE_YN (사용여부) — VARCHAR2
- PARENT_ID (상위코드 ID) — VARCHAR2
MEMBER (회원정보)
- MEMBER_ID (회원아이디) — VARCHAR2 — Primary key — NOT NULL
- MEMBER_PW (회원비밀번호) — VARCHAR2
- NICK_NM (닉네임) — VARCHAR2
- GRADE (회원등급) — VARCHAR2
- JOIN_DATE (가입일자) — DATE
MENU (메뉴)
- MENU_ID (메뉴ID) — VARCHAR2 — Primary key — NOT NULL
- MENU_NM (메뉴이름) — VARCHAR2
- PARENT_ID (상위메뉴ID) — VARCHAR2
- DISCRIPTION (메뉴설명) — VARCHAR2
- CODE_LIST (키워드분류) — VARCHAR2
- IMAGE_PATH (이미지경로) — VARCHAR2
- CONE_ID (코드ID) — VARCHAR2 — Foreign key → COMMONCODE.CONE_ID — NOT NULL
PUSH (추천기록)
- MEMBER_ID (회원아이디) — VARCHAR2
- BOARD_NO (게시글번호) — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL
REPLY (댓글)
- REPLY_NO (댓글번호) — NUMBER — Primary key — NOT NULL
- MEMBER_ID (회원아이디) — VARCHAR2 — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- BOARD_NO (게시글번호) — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL
- CONTENT (댓글내용) — VARCHAR2
- DATE (작성일시) — DATE
- NICK (작성자 닉네임) — VARCHAR2
RESTAURANT (식당정보)
- REST_ID (식당ID) — VARCHAR2 — Primary key — NOT NULL
- REST_NM (식당이름) — VARCHAR2
- MAIN_CATE (대분류) — VARCHAR2
- SUB_CATE (소분류) — VARCHAR2
- REST_STATE (폐업여부) — VARCHAR2
- REST_ADDR (주소) — VARCHAR2
- REST_LAT (위도) — VARCHAR2
- REST_LNG (경도) — VARCHAR2
- OPEN_TIME (영업시간) — VARCHAR2
- RESTCOUNT (추천수) — NUMBER
RESTMENU (식당메뉴)
- RMENU_ID (메뉴ID) — VARCHAR2 — Primary key — NOT NULL
- REST_ID (식당ID) — VARCHAR2 — Foreign key → RESTAURANT.REST_ID — NOT NULL
- MENU_ID (메뉴 카테고리ID) — VARCHAR2 — Foreign key → MENU.MENU_ID — NOT NULL
- RMENU_NM (메뉴이름) — VARCHAR2
- PRICE (가격) — NUMBER
REVIEW (후기)
- REVIEW_NO (후기번호) — NUMBER — Primary key — NOT NULL
- MEMBER_ID (회원아이디) — VARCHAR2 — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- REST_ID (식당ID) — VARCHAR2 — Foreign key → RESTAURANT.REST_ID — NOT NULL
- REVIEW_LEVEL (식당평가) — VARCHAR2
- REVIEW_CONTENT (한줄후기) — VARCHAR2
- REVIEW_DATE (후기작성일자) — DATE
- ENTER_DATE (방문일자) — DATE