assignment

Tables (3)

Article (게시글)

  • article_id (게시글 고유번호) — BIGINT — Primary key — NOT NULL
  • member_id (멤버 고유번호) — BIGINT — Foreign key → Member.member_id — NOT NULL
  • title (제목) — VARCHAR
  • content (내용) — TEXT

Comment (댓글)

  • comment_id (댓글 고유번호) — BIGINT — Primary key — NOT NULL
  • article_id (게시글 고유번호) — BIGINT — Foreign key → Article.article_id — NOT NULL
  • member_id (멤버 고유번호) — BIGINT — Foreign key → Member.member_id — NOT NULL
  • content (내용) — TEXT

Member (회원)

  • member_id (멤버 고유번호) — BIGINT — Primary key — NOT NULL
  • username (멤버 아이디) — VARCHAR
  • nickname (닉네임) — VARCHAR
  • password (비밀번호) — VARCHAR