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