new

Tables (5)

articles (게시글)

  • article_id (게시글 고유번호) — Primary key — NOT NULL
  • member_id (회원 고유번호) — Foreign key → members.member_id — NOT NULL
  • title (제목)
  • content (내용)
  • writer (작성자)

cafe (Untitled)

  • cafe_id (Key) — Primary key — NOT NULL
  • theme_id (Key2) — Foreign key → theme.theme_id — NOT NULL

members (회원)

  • member_id (회원 고유번호) — Primary key — NOT NULL
  • nickname (닉네임)

reviews (리뷰)

  • review_id (리뷰 고유번호) — Primary key — NOT NULL
  • member_id (회원 고유번호) — Foreign key → members.member_id — NOT NULL
  • article_id (게시글 고유번호) — Foreign key → articles.article_id — NOT NULL
  • content (내용)
  • writer (작성자)

theme (Untitled2)

  • theme_id (Key) — Primary key — NOT NULL