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