refolio
Tables (7)
Favorite
- id (PK) — bigint — Primary key — NOT NULL
- user_id (FK2) — bigint — Foreign key → User.id — NOT NULL
- portfolio_id (FK) — bigint — Foreign key → Portfolio.id — NOT NULL
Feedback
- id (PK) — bigint — Primary key — NOT NULL
- portfolio_id (FK) — bigint — Foreign key → Portfolio.id — NOT NULL
- user_id (FK2) — bigint — Foreign key → User.id — NOT NULL
- content (Field) — varchar(3000)
Images
- id (PK) — bigint — Primary key — NOT NULL
- portfolio_id (FK) — bigint — Foreign key → Portfolio.id — NOT NULL
- url (Field) — varchar(100)
- name (Field2) — varchar(20)
Portfolio
- id (PK) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.id — NOT NULL
- title (Field) — varchar(50)
- description (Field2) — varchar(200)
- content (Field3) — varchar(5000)
- thumbnail_img (Field4) — varchar(100)
- github_url (Field5) — varchar(100)
- demo_url (Field6) — varchar(100)
Recommendation
- id (PK) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.id — NOT NULL
- portfolio_id (FK2) — bigint — Foreign key → Portfolio.id — NOT NULL
Tag
- id (Key) — bigint — Primary key — NOT NULL
- portfolio_id (FK) — bigint — Foreign key → Portfolio.id — NOT NULL
- title (Field) — varchar(15)
User
- id (PK) — bigint — Primary key — NOT NULL
- username (Field) — varchar(15)
- password (Field2) — varchar(255)
- nickname (Field3) — varchar(15)