날씨

테이블 (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