Wine Select ERD
테이블 (6)
MEMBER (회원정보)
- MEM_ID — VARCHAR2(50) — 기본 키
- MEM_PASS — VARCHAR2(50)
- MEM_NAME — VARCHAR2(40)
- MEM_BIRTH — VARCHAR2(40)
- MEM_TEL — VARCHAR2(15)
- MEM_EMAIL — VARCHAR2(50)
MEM_LIKE (회원 즐겨찾기)
- MEM_ID (FK) — VARCHAR2(50) — 외래 키 → MEMBER.MEM_ID
- WINE_CODE (PK) — VARCHAR2(50) — 외래 키 → WINE_INFORMATION.WINE_CODE
- WINE_LIKE (Field) — NUMBER(1)
Untitled
- COMM_NUM (PK) — NUMBER(10) — 기본 키 — NOT NULL
- B_NUM (FK) — NUMBER(10) — 외래 키 → 게시판.PRIMARY KEY
- COM_REG_DATE (Field) — VARCHAR2(50)
- COM_CONTENT (Field2) — VARCHAR2(200)
WINE_COMMENTS (와인 댓글)
- WINECOMM_NUM (PK) — NUMBER(10) — 기본 키 — NOT NULL
- WINE_CODE (FK) — VARCHAR2(50) — 외래 키 → WINE_INFORMATION.WINE_CODE
- WINECOMM_CONTENT (Field) — VARCHAR2(200)
- WINECOMM_DATE (Field2) — VARCHAR2(50) — NOT NULL
WINE_INFORMATION (와인 정보)
- WINE_CODE (PK) — VARCHAR2(50) — 기본 키
- WINE_NAME (NotNull) — VARCHAR2(50) — NOT NULL
- WINE_COUNTRY (Field) — VARCHAR2(50)
- WINE_FLV (Field2) — VARCHAR2(200)
- WINE_PRICE (Field3) — NUMBER(200)
- WINE_IMG (Field6) — VARCHAR(200)
- WINE_INFO (Field4) — VARCHAR2(500)
- WINE_AVG (Field5) — NUMBER(2, 1)
- WINE_TAG (Field7) — VARCHAR2(50)
게시판 (BOARED)
- PRIMARY KEY (B_NUM) — NUMBER(10) — 기본 키
- MEM_ID (pk) — VARCHAR2(50)
- B_GUBUN (Field) — VARCHAR2(50)
- B_REG_DATE (Field2) — VARCHAR2(50)
- B_TITLE (Field3) — VARCHAR2(50)
- B_CONTENT (Field4) — VARCHAR2(200)
- B_READCOUNT (Field5) — NUMBER(10)
- B_IMAGE1 (Field6) — VARCHAR2(200)
- B_RECOMMEND (Field7) — NUMBER(10)