assignment2

Tables (13)

CHARTROOM (Untitled5)

  • chatroom_id (Key) — INT — Primary key — NOT NULL
  • room_name (Field) — VARCHAR2

CHATROOM_MEMBER (Untitled11)

  • member_id (Key) — INT — Primary key — NOT NULL
  • last_read_at (Field) — VARCHAR2
  • user_id (Key2) — INT — Foreign key → USER.user_id — NOT NULL
  • chatroom_id (Key3) — INT — Foreign key → CHARTROOM.chatroom_id — NOT NULL

FRIENDSHIP (Untitled13)

  • friendship_id (Key) — INT — Primary key — NOT NULL
  • status (Field) — VARCHAR2
  • requested_at (Field2) — VARCHAR2
  • register_id (Key2) — INT — Foreign key → USER.user_id — NOT NULL
  • Reciver_id (Key3) — INT — Foreign key → USER.user_id — NOT NULL

GAME (Untitled3)

  • game_id (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR2
  • price (Field2) — INT
  • publisher (Field3) — VARCHAR2

GAME_GENRE (Untitled10)

  • game_id (Key3) — INT — Foreign key → GAME.game_id — NOT NULL
  • genre_id (Key) — INT — Foreign key → GENRE.genre_id — NOT NULL

GENRE (Untitled4)

  • genre_id (Key) — INT — Primary key — NOT NULL
  • genre_name (Field) — VARCHAR2

MESSAGE (Untitled7)

  • message_id (Key) — INT — Primary key — NOT NULL
  • content (Field) — VARCHAR2
  • sent_at (Field2) — VARCHR2
  • chatroom_id (Key2) — INT — Foreign key → CHARTROOM.chatroom_id — NOT NULL
  • user_id (Key3) — INT — Foreign key → USER.user_id — NOT NULL

PLAY_HISTORY (Untitled9)

  • history_id (Key) — INT — Primary key — NOT NULL
  • start_time (Field) — VARCHAR2
  • end_time (Field2) — VARCHAR2
  • play_time (Field3) — VARCHAR2
  • Field4
  • user_id (Key2) — INT — Foreign key → USER.user_id — NOT NULL
  • game_id (Key3) — INT — Foreign key → GAME.game_id — NOT NULL

PURCHASE (Untitled8)

  • purchase_id (Key) — INT — Primary key — NOT NULL
  • purchase_date (Field) — VARCHAR2
  • purchase_price (Field2) — INT
  • user_id (Key2) — INT — Foreign key → USER.user_id — NOT NULL
  • game_id (Key3) — INT — Foreign key → GAME.game_id — NOT NULL

REVIEW (Untitled6)

  • review_id (Key) — INT — Primary key — NOT NULL
  • content (Field) — VARCHAR2
  • rating (Field2) — INT
  • user_id (Key2) — INT — Foreign key → USER.user_id — NOT NULL
  • game_id (Key3) — INT — Foreign key → GAME.game_id — NOT NULL

STREAM (Untitled2)

  • stream_id (Key) — INT — Primary key — NOT NULL
  • channel_name (Field) — varchar2
  • category (Field2) — varchar2
  • user_id (Key2) — INT — Foreign key → USER.user_id — NOT NULL

STREAM_FOLLOW (Untitled12)

  • follow_id (Key) — INT — Primary key — NOT NULL
  • followed_at (Field) — VARCHAR2
  • user_id (Key2) — INT — Foreign key → USER.user_id — NOT NULL
  • stream_id (Key3) — INT — Foreign key → STREAM.stream_id — NOT NULL

USER (Untitled)

  • user_id (Key) — INT — Primary key — NOT NULL
  • username (Field) — VARCHAR2
  • email (Field2) — VARCHAR2
  • nickname (Field3) — VARCHAR2
  • created_at (Field4) — VARCHAR2