pr2_erd

Tables (4)

imglike (Untitled3)

  • imglikeidx (Key) — PK — Primary key — NOT NULL
  • imglike (Field1)
  • userid (Field2) — FK
  • useridx (INT2) — PK — Foreign key → user.useridx — NOT NULL

musiclike (Untitled4)

  • musiclikeidx (Key) — PK — Primary key — NOT NULL
  • musiclike (Field1)
  • userid (Field2) — FK
  • useridx (INT2) — PK — Foreign key → user.useridx — NOT NULL

postimg (Untitled2)

  • postimgidx (Key) — PK — Primary key — NOT NULL
  • postimg (Field)
  • userid (Field2) — FK
  • useridx (INT2) — PK — Foreign key → user.useridx — NOT NULL
  • imglikeidx (INT3) — PK — Foreign key → imglike.imglikeidx — NOT NULL

user (Untitled)

  • useridx (Key) — PK — Primary key — NOT NULL
  • userid (Field1)
  • pw (Field2)
  • email (Field3)
  • nickname (Field4)
  • userimg (Field5)