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