날씨
테이블 (5)
Add (Untitled2)
- Add_No (Int(8)) — "00000000" — 기본 키 — NOT NULL
- Add_Name (Varchar(10))
- Add_U_Name (Vacrhar(6))
- Price (int(10)) — "000,000원"
- Add_Phone (Int(11)) — "00000000000"
Market (Untitled5)
- Market_Num (varchar(10)) — "AA00" — 기본 키 — NOT NULL
- Member_Num (int(8)) — YY-"0000" — 외래 키 → Member.Member_Num — NOT NULL
Member (Untitled)
- Member_Num (int(8)) — YY-"0000" — 기본 키 — NOT NULL
- Member_ID (varchar(16)) — Unique Key
- Password (varchar(14))
- Email (varchar(20)) — Unique Key
- User_Phone (int(11)) — "00000000000"
Mileage (Untitled4)
- Point (int(10))
- Member_Num (int(8)) — YY-"0000" — 외래 키 → Member.Member_Num — NOT NULL
- Add_No (Int(8)) — "00000000" — 외래 키 → Add.Add_No — NOT NULL
- Market_Num (varchar(10)) — "AA00" — 외래 키 → Market.Market_Num — NOT NULL
Weather (Untitled3)
- Date — "YYYY/MM/DD"
- Address (Varchar(30))
- W_name (Varchar(5))
- Temp (Vacrhar(7)) — "00℃"
- Dust (varchar(10)) — "0000ppm"
- Member_Num (int(8)) — YY-"0000" — 외래 키 → Member.Member_Num — NOT NULL