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 (읽음 여부)