postHere

Tables (8)

find

  • find_pk — INT — Primary key — NOT NULL — find 게시글 식별 고유값 auto_increment
  • writer_id — INT — NOT NULL
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • music_api_url — VARCHAR(300)
  • creation_date — TIMESTAMP — NOT NULL
  • expiration_date — TIMESTAMP — NOT NULL
  • readonly — TINYINT(1) — NOT NULL
  • content_capture_url — VARCHAR(300)
  • content_overwrite_url — VARCHAR(300)

following

  • following_pk — INT — Primary key — NOT NULL — auto_increment
  • user_info_pk — INT — Foreign key → user_info.user_info_pk — NOT NULL — 회원식별 고유값auto_increment
  • follower_id — INT — NOT NULL
  • followed_id — INT — NOT NULL

forum

  • forum_pk — INT
  • creation_date — TIMESTAMP — NOT NULL
  • writer_id — INT — NOT NULL
  • location — VARCHAR(100) — NOT NULL
  • contents_text — TEXT — NOT NULL
  • music_api_url — VARCHAR(300)

forum_comment

  • forum_comment_pk — INT
  • creation_date — TIMESTAMP — NOT NULL
  • forum_id — INT — NOT NULL
  • writer_id — INT — NOT NULL
  • contents_text — TEXT — NOT NULL

forum_img

  • img_pk — INT
  • forum_id — INT — NOT NULL
  • img_url — VARCHAR(300) — NOT NULL

forum_like

  • forum_like_pk — INT
  • forum_id — INT — NOT NULL
  • forum_liker_id — INT — NOT NULL

park

  • park_pk — INT
  • owner_id — INT — NOT NULL
  • content_capture_url — VARCHAR(300)

user_info

  • user_info_pk — INT — Primary key — NOT NULL — 회원식별 고유값auto_increment
  • login_id — CHAR(20) — NOT NULL — 회원이 로그인 시 사용하는 계정ID
  • login_pw — VARCHAR(100) — NOT NULL — 회원이 로그인 시 사용하는 계정ID
  • email — VARCHAR(50) — NOT NULL — 회원가입 시 개인인증수단
  • phone — VARCHAR(20) — NOT NULL — 회원가입 시 개인인증수단
  • profile_id — VARCHAR(20) — NOT NULL — 서비스상에서 사용자간 표시할 ID
  • profile_photo_url — VARCHAR(300) — NOT NULL — 프로필 이미지 리소스 경로(URL)