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