LymTaxi

Tables (3)

Accounts (Untitled)

  • id — VARCHAR(20) — Primary key — NOT NULL
  • password — VARCHAR(128)
  • name — VARCHAR
  • email — VARCHAR
  • account_number — VARCHAR
  • picture — VARCHAR — URL
  • complements — INTEGER

Channels (Untitled2)

  • id — ulong — Primary key — NOT NULL
  • host_id — ulong
  • name — VARCHAR — NOT NULL — CHECK IF LENGTH > 0
  • departure — TIME — NOT NULL
  • destination — BOOL — NOT NULL — TRUE == 학교 FALSE == 역
  • sex — BOOL — true == 남성 false == 여성 null == 모두
  • state — INTEGER — NULL == 정산 대기 0 == 정산 완료 0 > 정산 금액

Participants (Untitled3)

  • id (user_id) — VARCHAR(20) — Foreign key → Accounts.id — NOT NULL
  • id (channel_id) — ulong — Foreign key → Channels.id — NOT NULL
  • is_GPS_enabled — BOOL