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