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