gikhub

Tables (6)

comment (댓글)

  • 댓글번호 (comment_no) — int — Primary key — NOT NULL
  • 댓글작성자 id (member_id) — varchar(20) — Foreign key → member.회원 id — NOT NULL
  • 토크토크방 id (talktalk_id) — int — Foreign key → talktalk.토크토크방 id — NOT NULL
  • 댓글내용 (comment_content) — varchar(200) — NOT NULL
  • 작성일시 (reg_date) — DATETIME — NOT NULL

member (회원)

  • 회원 id (member_id) — varchar(20) — Primary key — NOT NULL
  • 이름 (member_name) — varchar(5) — NOT NULL
  • 학교메일 (email) — varchar(20) — NOT NULL
  • 비밀번호 (password) — varchar(20) — NOT NULL
  • 전화번호 (phonenumber) — int(11) — NOT NULL
  • 닉네임 (nickname) — varchar(20) — NOT NULL

money_info (Untitled)

  • money_info_id — Primary key — NOT NULL
  • 방 유형 (room_type) — Foreign key → together_team.방 유형 — NOT NULL
  • 같이방 id (room_id) — int — Foreign key → together_team.같이방 id — NOT NULL
  • 목표 금액 (goal_money) — int — NOT NULL
  • 배달비 (delivery_fee) — int
  • 현재 금액 (current_money)

participant (방 참가자)

  • 방 참가자 id (member_id) — varchar(20) — Foreign key → member.회원 id — NOT NULL
  • 같이방 id (room_id) — int — Foreign key → together_team.같이방 id — NOT NULL

talktalk (토크토크)

  • 토크토크방 id (talktalk_id) — int — Primary key — NOT NULL
  • 글쓴이 id (member_id) — varchar(20) — Foreign key → member.회원 id — NOT NULL
  • 작성일시 (reg_date) — DATETIME — NOT NULL
  • 토크토크내용 (talktalk_content) — varchar(200) — NOT NULL

together_team (같이 방)

  • 같이방 id (room_id) — int — Primary key — NOT NULL
  • 방 유형 (room_type) — Primary key — NOT NULL
  • 방장 id (member_leader_id) — varchar(20) — Foreign key → member.회원 id — NOT NULL
  • 스토어 이름 (store_name) — varchar(20) — NOT NULL
  • 마감 기한 (deadline) — datetime — NOT NULL
  • 배송 기숙사 (receive_domitory) — varchar(20) — NOT NULL
  • 최대 구매 인원 (max_member) — int