DB

Tables (4)

category (카테고리)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → client.Key — NOT NULL
  • food (음식)
  • hotel (호텔)
  • trip (여행)
  • Key (Key3) — Foreign key → client.Key — NOT NULL

client (고객정보)

  • Key — Primary key — NOT NULL
  • client_ID (고객아이디) — varchar2
  • client_PW (고객 비번)
  • client_name (고객이름)
  • client_num (고객번호)
  • (Field)

local_name (지역이름)

  • 서울 (seoul) — varchar2
  • 경기 (gyeonggi)
  • 강원 (gangwon)

star (즐겨찾기)

  • Field (즐겨찾기날짜)
  • Field (고객아이디)
  • Field (내용)