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)