School-Newsfeed
Tables (5)
account (계정)
- account_id — 기본키 — Primary key — NOT NULL
- email — 이메일
- password — 비밀번호
- name — 이름
- role — 역할
school_news (학교 소식)
- school_news_id — 기본키 — Primary key — NOT NULL
- subject — 제목
- content — 내용
- deleted_at — 삭제 날짜
- created_at — 생성 날짜
- updated_at — 수정 날짜
- school_page_id — 학교 페이지ID — Foreign key → school_page.school_page_id — NOT NULL
- created_by — 제작자 — Foreign key → account.account_id — NOT NULL
school_newsfeed (뉴스피드)
- account_id — 계정ID — Foreign key → account.account_id — NOT NULL
- school_news_id — 학교 소식ID — Foreign key → school_news.school_news_id — NOT NULL
school_page (학교 페이지)
- school_page_id — 기본키 — Primary key — NOT NULL
- school_name — 학교명
- area — 지역
- admin_id — 관리자ID — Foreign key → account.account_id — NOT NULL
subscriber (구독자)
- school_page_id — 학교 페이지ID — Foreign key → school_page.school_page_id — NOT NULL
- account_id — 계정ID — Foreign key → account.account_id — NOT NULL