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