RLAND

Tables (5)

CATEGORY (카테고리)

  • ID (아이디) — NUMBER — Primary key — NOT NULL
  • NAME (이름) — VARCHAR2(100)

MEMBER (회원)

  • ID (아이디) — NUMBER — Primary key — NOT NULL
  • NICK_NAME (닉네임) — VARCHAR2(255)
  • PWD (비밀번호) — VARCHAR2(255)
  • TYPE (타입) — NUMBER(1)
  • RCMD_MEMBER_ID (등록회원아이디) — NUMBER

MENU (메뉴)

  • ID (아이디) — NUMBER — Primary key — NOT NULL
  • KOR_NAME (한글이름) — NVARCHAR2(500)
  • ENG_NAME (영문이름) — VARCHAR2(500)
  • PRICE (가격) — VARCHAR2
  • REG_DATE (등록일) — TIMESTAMP(6)
  • REG_MEMBER_ID (등록자) — NUMBER
  • DESCRIPTION (설명) — VARCHAR2(1000)
  • CATEGORY_ID (카테고리ID) — NUMBER — Foreign key → CATEGORY.ID — NOT NULL

MENU_IMAGE (매뉴이미지)

  • ID (아이디) — NUMBER — Primary key — NOT NULL
  • SRC (이미지) — VARCHAR2(100)
  • IS_DEFAULT (대표이미지) — NUMBER(1)=0
  • MENU_ID (메뉴아이디) — NUMBER — Foreign key → MENU.ID — NOT NULL

RCMD_MENU (추천 메뉴)

  • ID (아이디) — NUMBER — Primary key — NOT NULL
  • R_MENU_ID (추천매뉴아이디) — NUMBER
  • MEMBER_ID (등록회원) — NUMBER(1)=0
  • MENU_ID (메뉴아이디) — NUMBER — Foreign key → MENU.ID — NOT NULL