Foss

Tables (6)

Alarm (알람)

  • 알라id (id) — not null — Primary key — NOT NULL
  • 멤버 id (memberId) — not null — Foreign key → Member.멤버 id — NOT NULL
  • 제목 (title) — not null
  • 내용 (content) — not null
  • 이동할 url (url)
  • 이미지 (ing)

Member (유저)

  • 멤버 id (id) — not null — Primary key — NOT NULL
  • 이메일 (field) — not null
  • 비밀번호 (password) — not null

Token (FCM 토큰)

  • 토큰id (id) — not null — Primary key — NOT NULL
  • 멤버 id (memberId) — not null — Foreign key → Member.멤버 id — NOT NULL
  • 토큰 값 (tokenValue) — not null
  • 토큰 만료기한 (expirationDate) — not null

Topic (FCM토픽)

  • 토픽id (topicId) — not null — Primary key — NOT NULL
  • 토픽명 (topicName) — not null

Topic_Member (토픽_멤버(다대다))

  • 토픽_멤버id (id) — not null — Primary key — NOT NULL
  • 토픽id (topicId) — not null — Foreign key → Topic.토픽id — NOT NULL
  • 멤버 id (memberId) — not null — Foreign key → Member.멤버 id — NOT NULL

Topic_Token (토픽_토큰(다대다))

  • 토픽_토큰id (id) — not null — Primary key — NOT NULL
  • 토픽id (topicId) — not null — Foreign key → Topic.토픽id — NOT NULL
  • 토큰id (tokenId) — not null — Foreign key → Token.토큰id — NOT NULL