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