lost-no-more
Tables (7)
Category (대분류)
- id (카테고리 id) — BIGINT — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
Location (위치)
- id (위치 id) — BIGINT — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
- latitude — FLOAT — NOT NULL
- longtitude — FLOAT — NOT NULL
- region — VARCHAR — NOT NULL
LostItem (습득물)
- id (습득물 id) — BIGINT — Primary key — NOT NULL
- category_id (카테고리 id) — BIGINT — Foreign key → Category.id — NOT NULL
- location_id (위치 id) — BIGINT — Foreign key → Location.id — NOT NULL
- color — VARCHAR — NOT NULL
- image — VARCHAR — NOT NULL
- name — VARCHAR — NOT NULL
- title — VARCHAR — NOT NULL
- date — DATE — NOT NULL
Notification (알림)
- id (알림 id) — BIGINT — Primary key — NOT NULL
- category_id (카테고리 id) — BIGINT — Foreign key → Category.id — NOT NULL
- total_count — BIGINT
- date — DATE
Subscribe (구독)
- id (구독 id) — BIGINT — Primary key — NOT NULL
- user_id (유저 id) — BIGINT — Foreign key → User.id — NOT NULL
- category_id (카테고리 id) — BIGINT — Foreign key → Category.id — NOT NULL
User (유저)
- id (유저 id) — BIGINT — Primary key — NOT NULL
- email — VARCHAR — NOT NULL
- nickname — VARCHAR — NOT NULL
UserNotification (유저 알림)
- id (유저 알림 id) — Primary key — NOT NULL
- user_id (유저 id) — BIGINT — Foreign key → User.id — NOT NULL
- notification_id (알림 id) — BIGINT — Foreign key → Notification.id — NOT NULL
- read_status (읽음 여부)