UOS-CONNECTION
Tables (9)
Alarm
- alarm_id (Key) — bigint(20) — Primary key — NOT NULL
- user_id (id) — bigint(20) — Foreign key → User.user_id — NOT NULL
- message (Field) — varchar(255)
- checked (Field3) — bool
- created_at (Field2) — timestamp
Chat Message
- id (Key) — bigint(20) — Primary key — NOT NULL
- room_id (Key2) — bigint(20) — Foreign key → Chat Room.room_id — NOT NULL
- sender_id (id) — bigint(20) — Foreign key → User.user_id — NOT NULL
- message (Field2) — varchar(255)
- checked (Field3) — bool
- created_at (Field4) — timestamp
Chat Room
- room_id (Key) — bigint(20) — Primary key — NOT NULL
- buyer_id (id) — bigint(20) — Foreign key → User.user_id — NOT NULL
- talent_id (Key2) — bigint(20) — Foreign key → Talent.talent_id — NOT NULL
- tool_id (Key3) — bigint(20) — Foreign key → Tool.tool_id — NOT NULL
- created_at (Field3) — timestamp
Talent
- talent_id (Key) — bigint(20) — Primary key — NOT NULL
- gosu_id (Key2) — bigint(20) — Primary key — NOT NULL
- category_id (Key3) — bigint(10) — Foreign key → Talent Category.category_id — NOT NULL
- title (Field) — varchar(20)
- description (Field2) — varchar(50)
- gosu (Field3) — varchar(20)
- view_count (Field7) — bigint(20)
- created_at (Field6) — timestamp
Talent Category
- category_id (Key) — bigint(10) — Primary key — NOT NULL
- category (Field) — varchar(20)
Tool
- tool_id (Key) — bigint(20) — Primary key — NOT NULL
- gosu_id (Key2) — bigint(20) — Primary key — NOT NULL
- category_id (Key3) — bigint(10) — Foreign key → Tool Category.category_id — NOT NULL
- title (Field2) — varchar(20)
- description (Field3) — varchar(20)
- gosu (Field4) — varchar(20)
- view_count (Field5) — bigint(20)
- created_at (Field6) — timestamp
Tool Category
- category_id (Key) — bigint(10) — Primary key — NOT NULL
- category (Field) — varchar(20)
User (user)
- user_id (id) — bigint(20) — Primary key — NOT NULL
- nickname — varchar(8)
- email (Field4) — varchar(20)
- password (Field2) — varchar(20)
- rating_score (Field3) — numeric(3,1)
- created_at (Field) — timestamp
- user_type (Field5) — ENUM
Wish List (Untitled)
- wish_list_id (Key) — bigint(20) — Primary key — NOT NULL
- user_id (id) — bigint(20) — Foreign key → User.user_id — NOT NULL
- talent_id (Key2) — bigint(20) — Foreign key → Talent.talent_id — NOT NULL
- tool_id (Key3) — bigint(20) — Foreign key → Tool.tool_id — NOT NULL
- created_at (Field) — timestamp