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