siso

Tables (5)

congressman (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(255)
  • party (Field2) — varchar(255)
  • times_elected (Field3) — int

dislike (CopyOfUntitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • rating_id (Key2) — bigint — Foreign key → rating.id — NOT NULL
  • congressman_id (Key3) — bigint — Foreign key → congressman.id — NOT NULL
  • dtype (Field) — varchar(31) — NOT NULL — like의 type을 구분하기 위한 값

like (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • rating_id (Key2) — bigint — Foreign key → rating.id — NOT NULL
  • congressman_id (Key3) — bigint — Foreign key → congressman.id — NOT NULL
  • dtype (Field) — varchar(31) — NOT NULL — like의 type을 구분하기 위한 값

member (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • kakai_id (Field) — bigint
  • naver_id (Field2) — varchar(255)
  • image_url (Field3) — varchar(255)
  • nickname (Field4) — varchar(255)
  • refresh_token (Field5) — varchar(255)

rating (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → member.id — NOT NULL
  • congressman_id (Key3) — bigint — Foreign key → congressman.id — NOT NULL
  • rate (Field3) — double
  • content (Field) — varchar(255)