SEOUL PassPick
Tables (3)
basic_info (기본정보)
- info_id (Key) — Primary key — NOT NULL
- birth (생년월일) — date — NOT NULL
- multi_child (다자녀) — boolean — NOT NULL
- child_num (자녀수) — int
- low_income (저소득층) — boolean — NOT NULL
- others (Field)
transit_usage_pattern (대중교통 사용 패턴)
- id (식별아이디) — bigint — Primary key — NOT NULL — autoinc rement
- nickname (별칭) — varchar(10) — NOT NULL
- fare (편도 교통비) — bigint — NOT NULL
- count (이용 횟수) — int — NOT NULL
- info_id (Key) — Foreign key → basic_info.info_id — NOT NULL
- start (출발지)
- end (도착지)
user (사용자)
- user_id (Key) — Primary key — NOT NULL