Asiad ERD
Tables (12)
Cheer up (tbl_cheer)
- Cheer ID (id) — BIGINT(20) — Primary key — NOT NULL
- Description (description) — VARCHAR(255)
- Like Count (like_countL) — INT(11)
- Cheering Phrases (cheering_phrases) — VARCHAR(255)
- User Created Name (user _name) — VARCHAR(255)
- User Created Email (email) — VARCHAR(255)
- Created By (created_by) — VARCHAR(255) — NOT NULL
- Created Date (created_date) — DATETIME — NOT NULL
- Updated Date (updated_date) — DATETIME — NOT NULL
- User Created ID (user_id) — BIGINT(20) — Foreign key → User.User ID — NOT NULL
File (tbl_file)
- ID File (id) — BIGINT(20) — Primary key — NOT NULL
- Link (link) — VARCHAR(255) — NOT NULL
- File Name (name) — VARCHAR(255) — NOT NULL
- Object ID (object_id) — BIGINT(20) — NOT NULL — PROFILE, CONCEPT, POST, CHEER, FRAME, SPORT_CATEGORY, TIKTOK, COMMENT, VIDEO
- File Type (type) — VARCHAR(255) — NOT NULL — Type of subject that owns the photo
- Created Date (created_date) — DATETIME — NOT NULL
- Created By (created_by) — VARCHAR(255) — NOT NULL
Frame (tbl_frame)
- ID Frame (id) — BIGINT(20) — Primary key — NOT NULL
- Description (description) — VARCHAR(255)
- Created By (created_by) — VARCHAR(255) — NOT NULL
- Created Date (created_date) — DATETIME — NOT NULL
- Updated Date (updated_date) — DATETIME — NOT NULL
Frame Player (tbl_frame_player)
- ID (id) — BIGINT(20) — Primary key — NOT NULL
- Frame Type (type) — VARCHAR(255) — CHILD_1, CHILD_2, CHILD_3 - Position of each small frame in the large frame
- Created By (created_by) — VARCHAR(255) — NOT NULL
- Created Date (created_date) — DATETIME — NOT NULL
- Updated Date (updated_date) — DATETIME — NOT NULL
- Player ID (player_id) — BIGINT(20) — Foreign key → Player.Player ID — NOT NULL
- Frame ID (frame_id) — BIGINT(20) — Foreign key → Frame.ID Frame — NOT NULL
Player (tbl_player)
- Player ID (id) — BIGINT(20) — Primary key — NOT NULL
- Korean Name Player (name_kr) — VARCHAR(255)
- English Name Player (name_en) — VARCHAR(255)
- Player Birthday (birth_day) — DATETIME
- Created By (created_by) — VARCHAR(255) — NOT NULL
- Created Date (created_date) — DATETIME — NOT NULL
- Updated Date (updated_date) — DATETIME — NOT NULL
Post (tbl_post)
- Post ID (id) — BIGINT(20) — Primary key — NOT NULL
- Match Date (match_date) — DATETIME
- Created By (created_by) — VARCHAR(255) — NOT NULL
- Created Date (created _date) — DATETIME — NOT NULL
- Updated Date (updated_date) — DATETIME — NOT NULL
- Sport Category ID (sport_category_entity_id) — BIGINT(20) — Foreign key → Sport Category.Sport Category ID — NOT NULL
- User ID (user_id) — BIGINT(20) — Foreign key → User.User ID — NOT NULL
Role (tbl_role)
- Role ID (id) — BIGINT(20) — Primary key — NOT NULL
- Role Name (role) — VARCHAR(255) — NOT NULL — id 1 : ROLE_ADMIN, id 2 : ROLE_USER
Schedule (tbl_schedule)
- Schedule ID (id) — BIGINT(20) — Primary key — NOT NULL
- Content English (content_en) — VARCHAR(255)
- Content Korean (content_kr) — VARCHAR(255)
- Day Name English (day_name_en) — VARCHAR(255)
- Day Name Korean (day_name_kr) — VARCHAR(255)
- Round Name English (round_en) — VARCHAR(255)
- Round Name Korean (round_kr) — VARCHAR(255)
- Start Date (start_date) — DATETIME — NOT NULL
- Sport Category ID (sport_category_entity_id) — BIGINT(20) — Foreign key → Sport Category.Sport Category ID — NOT NULL
- Created By (created_by) — VARCHAR(255) — NOT NULL
- Created Date (created_date) — DATETIME — NOT NULL
- Update Date (updated_date) — DATETIME — NOT NULL
Sport Category (tbl_sport_category)
- Sport Category ID (id) — BIGINT(20) — Primary key — NOT NULL
- Sport Category Parent ID (parent_category_id) — BIGINT(20) — Foreign key → Sport Category.Sport Category ID — NOT NULL
- Name (name) — VARCHAR(255)
- Avatar (avatar) — VARCHAR(255)
- Created By (created_by) — VARCHAR(255) — NOT NULL
- Created Date (created_date) — DATETIME — NOT NULL
- Updated Date (updated_date) — DATETIME — NOT NULL
Sport Category Player (tbl_sport_category_player)
- ID (id) — BIGINT(20) — Primary key — NOT NULL
- Created By (created_by) — VARCHAR(255) — NOT NULL
- Created Date (created_date) — DATETIME — NOT NULL
- Updated Date (updated_date) — DATETIME — NOT NULL
- Player ID (player_id) — BIGINT(20) — Foreign key → Player.Player ID — NOT NULL
- Sport Category ID (sport_category_id) — BIGINT(20) — Foreign key → Sport Category.Sport Category ID — NOT NULL
User (tbl_user)
- User ID (id) — BIGINT(20) — Primary key — NOT NULL
- Email (email) — VARCHAR(255) — NOT NULL
- Password (password) — VARCHAR(255) — NOT NULL
- Account Type (account_type) — VARCHAR(255) — NOT NULL — BUSINESS, PERSONAL - Business account, Personal account
- Full Name (full_name) — VARCHAR(255)
- Login Type (login_type) — VARCHAR(255) — NOT NULL — LOCAL, NAVER - User login from system, User login from naver
- Phone Number (phone_number) — VARCHAR(12)
- Token Reset Password (reset_password_token) — VARCHAR(255)
- Account Enabled (enabled) — BIT(1) — NOT NULL — 0,1 - Account locked, Account not locked
- Created Date (created_date) — DATETIME — NOT NULL
User Role (tbl_user_role)
- User ID (id_user) — BIGINT(20) — Foreign key → User.User ID — NOT NULL — Id of the respective user
- Role ID (id_role) — BIGINT(20) — Foreign key → Role.Role ID — NOT NULL — Id of the respective role. Ex : id_user = 1, id_role = 2, it means user 1 has the role of admin