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)