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