MapMyParce

Tables (6)

Authentication (인증)

  • auth_id — INT — Primary key — NOT NULL
  • token — VARCHAR(500)
  • expires_at — TIMESTAMP
  • user_id — INT — Foreign key → User.user_id — NOT NULL

Manufacturer (제조업체)

  • manufacturer_id — INT — Primary key — NOT NULL
  • business_name — VARCHAR(100)
  • business_code — VARCHAR(50)
  • address — VARCHAR(255) — NOT NULL
  • latitude — DECIMAL(10, 8) — NOT NULL
  • longitude — DECIMAL(11, 8) — NOT NULL

Map (지도)

  • map_id — INT — Primary key — NOT NULL
  • latitude
  • longitude
  • manufacturer_id — INT — Foreign key → Manufacturer.manufacturer_id — NOT NULL

Parcel (송장)

  • parcel_id — INT — Primary key — NOT NULL
  • tracking_number — VARCHAR(100) — UNIQUE
  • recipient_name — VARCHAR(100)
  • product_name — VARCHAR(100) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • user_id — INT — Foreign key → User.user_id — NOT NULL
  • manufacturer_id — INT — Foreign key → Manufacturer.manufacturer_id — NOT NULL

Role (역할)

  • role_id — INT — Primary key — NOT NULL
  • role_name — VARCHAR(50)

User (사용자)

  • user_id — INT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100),
  • role_id — INT — Foreign key → Role.role_id — NOT NULL