카핑
테이블 (5)
Account (이메일)
- id — NUMBER — 기본 키 — NOT NULL
- email — VARCHAR2(64) — NOT NULL
- verification_code — VARCHAR2(64) — NOT NULL — random64
- confirmed — CHAR(1) — Boolean
- user_id — NUMBER — 외래 키 → User.id — NOT NULL — Sequence
Avatar (아바타)
- id — NUMBER — 기본 키 — NOT NULL
- nick_name — VARCHAR2(64) — NOT NULL
- picture — VARCHAR2(255)
- picture_path — VARCHAR2(255)
User (회원)
- id — NUMBER — 기본 키 — NOT NULL — Sequence
- avatar_id — NUMBER — 외래 키 → Avatar.id — NOT NULL
- password — VARCHAR2(64) — NOT NULL
- enabled — CHAR(1) — NOT NULL — 0: disabled 1: enabled
Vehicle (차량)
- id — NUMBER — 기본 키 — NOT NULL
- user_id — NUMBER — 외래 키 → User.id — NOT NULL — Sequence
- brand_id — NUMBER — 외래 키 → Vehicle_Brand.id — NOT NULL
- vehicle_information_number (vehicle_certification_card) — CHAR(17)
- vehicle_name — VARCHAR2(64)
Vehicle_Brand (제조사)
- id — NUMBER — 기본 키 — NOT NULL
- brand_code — CHAR(1)
- brand_name — VARCHAR2(64)
- brand_eng_name — VARCHAR2(64)