drawly

Tables (8)

comments (댓글)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • content (내용) — VARCHAR(400) — NOT NULL
  • created_at (등록_일시) — DATETIME — NOT NULL
  • updated_at (수정_일시) — DATETIME — NOT NULL
  • deleted_at (삭제_일시) — DATETIME
  • diary_id (일기_아이디) — BIGINT — Foreign key → diaries.id — NOT NULL
  • gallery_id (갤러리_아이디) — BIGINT — Foreign key → galleries.id — NOT NULL
  • user_id (작성자_아이디) — BIGINT — Foreign key → users.id — NOT NULL

diaries (일기)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • title (제목) — VARCHAR(100) — NOT NULL
  • content (내용) — TEXT — NOT NULL
  • emoji (이모지) — VARCHAR(10)
  • weather (날씨) — VARCHAR(20) — SUNNY | CLOUDY ....
  • latitude (위도) — DOUBLE
  • longitude (경도) — DOUBLE
  • place_name (장소명) — VARCHAR(255)
  • image_url (이미지_URL) — VARCHAR(512)
  • created_at (등록_일시) — DATETIME — NOT NULL
  • updated_at (수정_일시) — DATETIME — NOT NULL
  • deleted_at (삭제_일시) — DATETIME
  • user_id (작성자_아이디) — BIGINT — Foreign key → users.id — NOT NULL — users.id

galleries (갤러리)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • name (갤러리_이름) — VARCHAR(100) — NOT NULL
  • image_url (이미지_URL) — VARCHAR(512)
  • invite_code (초대_코드) — VARCHAR(20) — NOT NULL
  • created_at (등록_일시) — DATETIME — NOT NULL
  • updated_at (수정_일시) — DATETIME — NOT NULL
  • deleted_at (삭제_일시) — DATETIME
  • user_id (방장_아이디) — BIGINT — Foreign key → users.id — NOT NULL — users.id

gallery_diaries (갤러리_일기)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • created_at (등록_일시) — DATETIME — NOT NULL
  • updated_at (수정_일시) — DATETIME — NOT NULL
  • deleted_at (삭제_일시) — DATETIME
  • diary_id (일기_아이디) — BIGINT — Foreign key → diaries.id — NOT NULL
  • gallery_id (갤러리_아이디) — BIGINT — Foreign key → galleries.id — NOT NULL

gallery_users (갤러리_참여자)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • created_at (등록_일시) — DATETIME — NOT NULL
  • updated_at (수정_일시) — DATETIME — NOT NULL
  • deleted_at (삭제_일시) — DATETIME
  • user_id (참여자_아이디) — BIGINT — Foreign key → users.id — NOT NULL
  • gallery_id (갤러리_아이디) — BIGINT — Foreign key → galleries.id — NOT NULL

payment_receipts (결제_영수증)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • payment_provider (제공처_구분) — VARCHAR(20) — NOT NULL — GOOGLE | APPLE ...
  • product_id (상품_아이디) — VARCHAR(100) — NOT NULL
  • purchase_token (결제_검증_토큰) — TEXT — NOT NULL
  • transaction_id (거래_아이디) — VARCHAR(100) — NOT NULL
  • expired_at (갱신_일자) — DATETIME — NOT NULL
  • created_at (등록_일시) — DATETIME — NOT NULL
  • updated_at (수정_일시) — DATETIME — NOT NULL
  • deleted_at (삭제_일시) — DATETIME
  • user_id (결제자_아이디) — BIGINT — Foreign key → users.id — NOT NULL

reactions (리액션)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • emoji (이모지) — VARCHAR(10) — NOT NULL
  • created_at (등록_일시) — DATETIME — NOT NULL
  • diary_id (일기_아이디) — BIGINT — Foreign key → diaries.id — NOT NULL
  • gallery_id (갤러리_아이디) — BIGINT — Foreign key → galleries.id — NOT NULL
  • user_id (작성자_아이디) — BIGINT — Foreign key → users.id — NOT NULL

users (회원)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • provider (소셜_로그인_제공처) — VARCHAR(20) — NOT NULL
  • social_id (소셜_고유_식별값) — VARCHAR(255) — NOT NULL
  • email (이메일) — VARCHAR(100) — 탈퇴 시 NULL
  • nickname (닉네임) — VARCHAR(50) — NOT NULL
  • profile_image_url (프로필_이미지_주소) — VARCHAR(512)
  • membership_status (멤버십_등급) — VARCHAR(20) — NOT NULL — FREE | PREMIUM
  • fcm_token (FCM_토큰) — TEXT
  • created_at (등록_일시) — DATETIME — NOT NULL
  • updated_at (수정_일시) — DATETIME — NOT NULL
  • deleted_at (삭제_일시) — DATETIME