mallery

Tables (4)

Album (앨범)

  • album_id (앨범 아이디) — NN — Primary key — NOT NULL
  • album_name (앨범 이름) — NN
  • member_cnt (사용자 수) — NN
  • created_date (생성일) — NN
  • modified_date (수정일) — NN

Member (사용자)

  • member_id (member 아이디) — NN — Primary key — NOT NULL
  • user_id (사용자 아이디) — NN
  • password (비밀번호) — NN
  • username (사용자 이름) — NN
  • phone_number (전화번호) — NN
  • created_date (생성일)
  • modified_date (수정일)

Post (게시물)

  • post_id (게시물 아이디) — NN — Primary key — NOT NULL
  • album_id (앨범 아이디) — NN — Foreign key → Album.album_id — NOT NULL
  • member_id (member 아이디) — NN — Foreign key → Member.member_id — NOT NULL
  • post_location (위치) — NN
  • post_date (날짜) — NN
  • is_updated (수정 여부) — NN
  • is_deleted (삭제 여부) — NN
  • image_paths (사진 경로) — NN
  • created_date (생성일) — NN
  • modified_date (수정일) — NN

comment (댓글)

  • comment_id (댓글 아이디) — NN — Primary key — NOT NULL
  • post_id (게시물 아이디) — NN — Foreign key → Post.post_id — NOT NULL
  • member_id (member 아이디) — NN — Foreign key → Member.member_id — NOT NULL
  • album_id (앨범 아이디) — NN — Foreign key → Post.album_id — NOT NULL
  • member_id (member 아이디2) — NN — Foreign key → Post.member_id — NOT NULL
  • content (댓글 내용) — NN
  • deleted (삭제 여부)