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