카핑

테이블 (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)