VAMOS

Tables (11)

Team (チーム)

  • userIdx (Key) — NUBMER — Foreign key → users.userIdx — NOT NULL
  • team_id (Field) — NUMBER
  • team_name (Field2) — VARCHAR2(100)
  • league_name (Field3) — VARCHAR2(100)
  • country (Field4) — VARCHAR2(100)

chat_message (Untitled8)

  • room_id (Key) — NUMBER — Primary key — NOT NULL
  • sender_id (Key2) — NUMBER — Primary key — NOT NULL
  • post_id (PRIMARY KEY2) — NUMBER — Foreign key → chat_room.post_id — NOT NULL
  • match_id (PRIMARY KEY22) — NUMBER — Foreign key → chat_room.match_id — NOT NULL
  • comment_id (PRIMARY KEY3) — NUMBER — Foreign key → chat_room.comment_id — NOT NULL
  • message_id (PRIMARY KEY) — NUMBER
  • message (Field2) — VARCHAR2(1000)
  • sent_at (Field3) — DATE DEFAULT SYSDATE

chat_room (Untitled7)

  • post_id (PRIMARY KEY2) — NUMBER — Foreign key → post.post_id — NOT NULL
  • match_id (PRIMARY KEY22) — NUMBER — Foreign key → post.match_id — NOT NULL
  • comment_id (PRIMARY KEY3) — NUMBER — Foreign key → post.comment_id — NOT NULL
  • room_id (PRIMARY KEY) — NUMBER
  • created_at (Field2) — DATE DEFAULT SYSDATE
  • Field

friend (Untitled6)

  • userIdx (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • friend_idx (PRIMARYKEY) — NUMBER — Primary key — NOT NULL
  • post_id (PRIMARY KEY2) — NUMBER — Foreign key → chat_room.post_id — NOT NULL
  • match_id (PRIMARY KEY22) — NUMBER — Foreign key → chat_room.match_id — NOT NULL
  • comment_id (PRIMARY KEY3) — NUMBER — Foreign key → chat_room.comment_id — NOT NULL
  • status (Field) — VARCHAR2(20)

league_standings (Untitled9)

  • team_id (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • played (Field) — NUMBER DEFAULT 0
  • wins (Field2) — NUMBER DEFAULT 0
  • draws (Field3) — NUMBER DEFAULT 0
  • losses (Field4) — NUMBER DEFAULT 0
  • goals_for (Field5) — NUMBER DEFAULT 0
  • goals_against (Field6) — NUMBER DEFAULT 0
  • goal_diff (Field7) — NUMBER GENERATED
  • points (Field8) — NUMBER DEFAULT 0
  • Field9

match (Untitled2)

  • match_id (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • home_team_id (Field) — NUMBER
  • away_team_id (Field2) — NUMBER
  • match_date (Field3) — DATE
  • home_score (Field4) — NUMBER
  • away_score (Field5) — NUMBER

player (Untitled)

  • player_id (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • post_id (PRIMARY KEY2) — NUMBER — Foreign key → post.post_id — NOT NULL
  • match_id (PRIMARY KEY22) — NUMBER — Foreign key → post.match_id — NOT NULL
  • comment_id (PRIMARY KEY3) — NUMBER — Foreign key → post.comment_id — NOT NULL
  • team_id (Field) — NUMBER
  • player_name (Field2) — VARCHAR2(100)
  • position (Field3) — VARCHAR2(10)
  • jersey_number (Field4) — NUMBER
  • nationality (Field5) — VARCHAR2(50)
  • birth_date (Field6) — DATE

post (Untitled3)

  • post_id (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • match_id (PRIMARY KEY2) — NUMBER — Foreign key → match.match_id — NOT NULL
  • comment_id (PRIMARY KEY3) — NUMBER — Foreign key → post_comment.comment_id — NOT NULL
  • userIdx (Field) — NUMBER
  • title (Field2) — VARCHAR2(200)
  • content (Field3) — CLOB
  • created_at (Field4) — DATE DEFAULT SYSDATE
  • updated_at (Field5) — DATE

post_comment (Untitled4)

  • comment_id (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • post_id (Field) — NUMBER
  • userIdx (Field2) — NUMBER
  • content (Field3) — VARCHAR2(1000)
  • created_at (Field4) — DATE DEFAULT SYSDATE
  • Field5

post_like (Untitled5)

  • post_id (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • userIdx (PRIMARYKEY) — NUMBER — Primary key — NOT NULL

users (ユーザー)

  • userIdx (Primary Key) — NUBMER — Primary key — NOT NULL
  • userId (Unique Key) — VARCHAR2(50)
  • userName (Field2) — VARCHAR2(50)
  • passwordHash (Field3) — VARCHAR2(128)
  • passwordSalt (Field4) — VARCHAR2(32)
  • email (Field5) — VARCHAR2(100)
  • phoneNumber (Field6) — VARCHAR2(20)
  • joinConfirm (Field7) — CHAR(1)
  • favorite_team_id (Field8) — NUMBER
  • create_at (Field9) — DATE DEFAULT SYSDATE
  • Field10
  • Field11