asrs
Tables (3)
Coustomer (고객)
- id (고객아이디) — String — Primary key — NOT NULL
- password (비밀번호) — String
- name (고객명) — String
- gender (성별) — String
- number (전화번호) — String
- age (나이) — Integer
- passportNo (여권번호) — String
- address (주소) — String
Reserve (예약)
- reserveId (예약번호) — Integer — Primary key — NOT NULL
- id (고객아이디) — String — Foreign key → Coustomer.id — NOT NULL
- uniqueNo (노선번호) — Integer — Foreign key → Route.uniqueNo — NOT NULL
- num (인원수) — Integer
- totalPrice (총가격) — Integer
Route (노선)
- uniqueNo (노선번호) — Integer — Primary key — NOT NULL
- reouteName (노선명) — String
- sAirNo (출발공항번호) — Integer
- aAirNo (도착공항번호) — Integer
- sAirName (출발공항이름) — String
- aAirName (도착공항이름) — String
- sTime (출발시간) — String
- aTime (도착시간) — String
- date (운행날짜) — String
- price (가격) — Integer