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 (내용)