gple

Tables (5)

Emoji

  • id (Key) — Long — Primary key — NOT NULL
  • thumbs_up_count (Field2) — Int
  • heart_count (Field) — Int
  • congrats_count (Field4) — Int
  • thinking_count (Field3) — Int
  • poop_count (Field5) — Int
  • china_count (Field6) — Int
  • id (게시물 식별자) — Long — Foreign key → Posts.id — NOT NULL
  • user_id (Key2) — Long — Foreign key → Posts.user_id — NOT NULL

Posts

  • id (게시물 식별자) — Long — Primary key — NOT NULL
  • user_id (Key) — Long — Foreign key → Users.id — NOT NULL
  • title (게시물 제목) — String
  • createdTime (게시물 생성 날짜) — Date
  • location (게시물 위치 정보) — String

Untitled2

  • Key — Primary key — NOT NULL
  • Field
  • Field2

Untitled3

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Key (Key3) — Foreign key → Untitled2.Key — NOT NULL

Users (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • username (Field) — String
  • stunum (Field2) — Long
  • email (Field3) — Long