fundon

Tables (5)

jwt_token (토큰)

  • token_id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → member.member_id — NOT NULL
  • grant_type (Field) — varchar
  • refresh_token (Field2) — varchar
  • created_at (Field4) — datetime
  • modified_at (Field5) — datetime

league (리그)

  • league_id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar

media (미디어)

  • media_id (Key) — bigint — Primary key — NOT NULL
  • content_type (Field) — varchar
  • mapping_content_id (Field2) — bigint
  • media_title (Field3) — varchar
  • media_upload_url (Field4) — varchar
  • media_url (Field5) — varchar
  • media_uuid_title (Field6) — varchar
  • represent_check (Field7) — char
  • type (Field8) — varchar
  • created_at (Field9) — datetime
  • modified_at (Field10) — datetime

member (회원)

  • member_id (Key) — bigint — Primary key — NOT NULL
  • account_type (Field) — char
  • address (Field2) — varchar
  • birth_date (Field3) — char
  • email (Field4) — varchar
  • gender (Field5) — char
  • league_id (Field6) — bigint
  • league_name (Field7) — varchar
  • live (Field8) — char
  • marketing_agreement (Field9) — char
  • personal_info_agreement (Field10) — char
  • name (Field11) — varchar
  • nick_name (Field12) — varchar
  • password (Field13) — varchar
  • phone (Field14) — char
  • postal_code (Field15) — char
  • profile_image (Field16) — varchar
  • team_id (Field18) — bigint
  • team_name (Field19) — varchar
  • created_at (Field20) — datetime
  • modified_at (Field21) — datetime

team (팀)

  • team_id (Key) — bigint — Primary key — NOT NULL
  • league_id (Key2) — bigint — Foreign key → league.league_id — NOT NULL
  • name (Field) — varchar