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