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