my_pinterest
Tables (9)
BOARD (Untitled3)
- PK (Key) — BIGINT — Primary key — NOT NULL
- 이름 (Field) — VARCHAR
- 참여자 (Field2) — VARCHAR
- 비밀 보드 여부 (Field3) — TININT
- 최종 수정일 (Field4) — LOCALDATETIME
- FK (Key2) — BIGINT — Foreign key → USER.PK — NOT NULL
CHAT
- PK (Key) — BIGINT — Primary key — NOT NULL
- FK (Key2) — BIGINT — Foreign key → USER.PK — NOT NULL
COMMENT (Untitled8)
- PK (Key2) — BIGINT — Foreign key → USER.PK — NOT NULL
- PK (Key) — BIGINT — Foreign key → PIN.PK — NOT NULL
- 댓글 (Field) — VARCHAR
- PHOTO (Field2) — TINYINT
- 댓글 단 시간 (Field3) — LOCALDATETIME
LIKE (Untitled7)
- PK (Key2) — BIGINT — Foreign key → USER.PK — NOT NULL
- PK (Key) — BIGINT — Foreign key → PIN.PK — NOT NULL
MESSAGE (Untitled2)
- PK (Key) — BIGINT — Primary key — NOT NULL
- 채팅 시간 (Field) — LOCALDATETIME
- 채팅 내용 (Field2) — VARCHAR
- PHOTO (Field3)
- FK (Key2) — BIGINT — Foreign key → CHAT.PK — NOT NULL
PIN (Untitled6)
- PK (Key) — BIGINT — Primary key — NOT NULL
- PHOTO (Field)
- 썸내일 (Field2)
- 설명 (Field3) — VARCHAR
- TITLE (Field4) — VARCHAR
- LINK (Field5) — VARCHAR
- 태그->10개 (Field6) — VARCHAR
- 댓글 가능 여부 (Field7) — TINYINT
- FK (Key2) — BIGINT — Foreign key → BOARD.PK — NOT NULL
SHARE_BOARD (Untitled9)
- PK (Key) — BIGINT — Foreign key → USER.PK — NOT NULL
- PK (Key2) — BIGINT — Foreign key → BOARD.PK — NOT NULL
SOCIAL_USER (Untitled4)
- PK (SOCIAL_ID) — BIGINT — Primary key — NOT NULL
- 공급자 (PROVIDER) — VARCHAR
USER (Untitled)
- PK (Key) — BIGINT — Primary key — NOT NULL
- EMAIL (Field) — VARCHAR
- 비밀번호 (Field2) — VARCHAR
- 생일 (Field3) — LOCALDATE
- 프로필사진 (Field4)
- 나를팔로우 (Field5) — BIGINT
- 내가팔로우 (Field6) — BIGINT
- REFRASH TOKEN (Field7) — VARCHAR
- 토큰 유효기간 (Field8) — LOCALDATETIME
- FK (SOCIAL_ID) — BIGINT — Foreign key → SOCIAL_USER.PK — NOT NULL