Copy dyna_gookgall

Tables (6)

approval_rating (지지율)

  • approval_rating_id (지지율 고유번호) — BIGINT, AI — Primary key — NOT NULL
  • member_id (멤버고유번호) — INT — Foreign key → member.member_id
  • congress_name (해당 국회의원 이름) — varchar(10)
  • approval_rating_status (1좋아요 2싫어요) — INT

congress_reply (국회의원 댓글)

  • congress_reply_id (국회의원 댓글) — BIGINT, AI — Primary key — NOT NULL
  • reply_id (댓글 고유번호) — BIGINT — Foreign key → reply.reply_id — NOT NULL
  • member_id (멤버고유번호) — BIGINT — Foreign key → member.member_id
  • congress_reply_content (해당 댓글 내용) — text
  • congress_reply_index (congress_reply_indexcongress_reply_index) — INT
  • congress_reply_create_date (국회의원 댓글 생성일) — DATETIME
  • congress_reply_modufy_date (국회의원 댓글 수정일) — DATETIME

favorites (즐겨찾기)

  • favorites_id (즐겨찾기 번호) — BIGINT, AI — Primary key — NOT NULL
  • member_id (멤버고유번호) — BIGINT, AI — Foreign key → member.member_id
  • mona_cd (국회의원 코드)

likes (좋아요)

  • likes_id (좋아요 고유번호) — BIGINT, AI — Primary key — NOT NULL
  • reply_id (댓글 고유번호) — INT — Foreign key → reply.reply_id — NOT NULL
  • member_id (멤버고유번호) — INT — Foreign key → member.member_id
  • lieks_type (좋아요 타입) — INT

member (멤버)

  • member_id (멤버고유번호) — BIGINT, AI — Primary key
  • member_login_id (멤버 로그인 아이디(이메일 형식)) — varchar(100)
  • member_login_pw (멤버 로그인 비밀번호) — varchar(255)
  • member_name (멤버 이름) — varchar(20)
  • member_role (멤버 권한(국회의원, 일반유저)) — varchar(20)
  • member_create_date (멤버 생성일) — DATETIME
  • member_modify_date (멤버 수정일) — DATETIME

reply (댓글)

  • reply_id (댓글 고유번호) — BIGINT, AI — Primary key — NOT NULL
  • member_id (멤버고유번호) — INT — Foreign key → member.member_id
  • mona_code (국회의원 고유번호) — INT
  • reply_content (댓글 내용) — text
  • reply_create_date (댓글 생성일) — DATETIME
  • reply_modify_date (댓글 수정일) — DATETIME