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)