2조입니다 ㅠㅠㅠㅠ

테이블 (4)

like (Untitled4)

  • 상품번호 (product_Num) — NUMBER — 외래 키 → product.상품번호 — NOT NULL
  • 상품이름 (product_name)

member (Untitled)

  • member_Num — NUMBER — 기본 키 — NOT NULL
  • member_Name — VARCHAR2(15)
  • member_Id — VARCHAR2(12)
  • member_Pw — VARCHAR2(18)
  • member_Tel — VARCHAR2(15)
  • member_Address — VARCHAR2(50)
  • member_Nickname — VARCHAR2(30)
  • member_Grade (Field7) — NUMBER(1)

message (Untitled3)

  • member_Num (Key) — NUMBER — 외래 키 → member.member_Num — NOT NULL
  • member_FromNickname (Field) — VARCHAR2(30)
  • message_Title (Field4) — VARCHAR2(30)
  • message_Content (Field2) — VARCHAR2(500)
  • message_Date (Field3) — DATE

product (Untitled2)

  • 상품번호 (product_Num) — NUMBER — 기본 키 — NOT NULL
  • 회원번호 (member_Num) — NUMBER — 외래 키 → member.member_Num — NOT NULL
  • 상품이름 (product_Name) — VARCHAR2(30)
  • 상품가격 (product_Price) — NUMBER
  • 상품카테고리 (product_Category) — VARCHAR2(30)
  • 상품설명 (product_Description) — VARCHAR2(500)
  • 상품사진URL (product_PictureUrl) — VARCHAR2(100)