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