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)