article
Tables (6)
Article (Untitled)
- articleId (기사아이디) — Long — Primary key — NOT NULL
- memberId (회원아이디) — Long — Foreign key → Member.memberId — NOT NULL
- title (제목) — String
- content (내용) — String
- date (작성일) — String
ArticleCategory (Untitled5)
- articleId (기사아이디) — Long — Foreign key → Article.articleId — NOT NULL
- categoryid (카테고리아이디) — Long — Foreign key → Cartegory.categoryid — NOT NULL
Cartegory (Untitled3)
- categoryid (카테고리아이디) — Long — Primary key — NOT NULL
- name (카테고리이름) — String
Comment (Untitled2)
- commentid (댓글아이디) — Long — Primary key — NOT NULL
- memberId (회원아이디) — Long — Foreign key → Member.memberId — NOT NULL
- articleId (기사아이디) — Long — Foreign key → Article.articleId — NOT NULL
- content (내용) — String
- date (작성일) — String
Like (Untitled4)
- memberId (회원아이디) — Long — Foreign key → Member.memberId — NOT NULL
- articleId (기사아이디) — Long — Foreign key → Article.articleId — NOT NULL
Member (회원)
- memberId (회원아이디) — Long — Primary key — NOT NULL
- password (비밀번호) — String
- name (이름) — String
- email (이메일) — String