kopmorning

테이블 (4)

게시물 (Article)

  • id (Article_Id) — BIGINT — 기본 키 — NOT NULL
  • id (Member_Id) — BIGI NT — 외래 키 → 멤버.id — NOT NULL
  • id (Team_id) — BIGINT — 외래 키 → 멤버.id — NOT NULL
  • title (Article_Title) — VARCHAR
  • body (Article_Body) — VARCHAR
  • likeCount (Article_LikeCount) — BIGINT
  • viewCount (Article_ViewCount) — BIGINT
  • coment (Article_Coment) — VARCHAR

게시물 댓글 (Article_Comment)

  • id (Comment_Id) — BIGINT — 기본 키 — NOT NULL
  • id (Member_Id) — BIGI NT — 외래 키 → 멤버.id — NOT NULL
  • id (Article_Id) — BIGINT — 외래 키 → 게시물.id — NOT NULL
  • id (Member_Id2) — BIGI NT — 외래 키 → 게시물.id — NOT NULL
  • id (Team_id) — BIGINT — 외래 키 → 멤버.id — NOT NULL
  • body (Comment_Body) — VARCHAR
  • likeCount (Comment_LikeCount) — BIGINT

멤버 (Member)

  • id (Member_Id) — BIGI NT — 기본 키 — NOT NULL
  • id (Team_id) — BIGINT — 외래 키 → 축구팀.id — NOT NULL
  • name (Member_Name) — VARCHAR
  • email (Member_Email) — CHAR
  • provider (Provider) — VARCHAR
  • provider_id (Provider_Id) — BIGINT
  • role (Member_Role) — VARCHAR

축구팀 (FootBall_Team)

  • id (Team_id) — BIGINT — 기본 키 — NOT NULL
  • name (Team_name) — CHAR
  • tla (Team_tla) — CHAR