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