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