wwww
Tables (10)
custom_match
- match_seq — bigint — Primary key — NOT NULL
- group_seq — bigint — Foreign key → group.group_seq — NOT NULL
- created_date — timestamp
- modified_date — timestamp
- del_yn — boolean
custom_user
- seq — bigint — Primary key — NOT NULL
- created_date — timestamp
- modified_date — timestamp
- nickname — varchar(255)
- summoner_id — varchar(255)
- group_seq — bigint
- del_yn — boolean
- account_id — varchar(60)
- tier_point — integer — 내전티어점수
group
- group_seq — bigint — Primary key — NOT NULL
- created_date — timestamp
- modified_date — timestamp
- group_name — varchar(30)
- owner — varchar(30)
group_auth
- group_auth_seq — bigint — Primary key — NOT NULL
- group_seq — bigint — Foreign key → group.group_seq — NOT NULL
- created_date — timestamp
- modified_date — timestamp
- group_auth — varchar(255)
- user_seq — bigint
match_attendees
- attendees_seq — bigint — Primary key — NOT NULL
- custom_user_seq — bigint — Foreign key → custom_user.seq — NOT NULL
- match_seq — bigint — Foreign key → custom_match.match_seq — NOT NULL
- created_date — timestamp
- modified_date — timestamp
- match_result — boolean
- position — varchar(255)
- team — varchar(1)
- del_yn — boolean
suggestion
- date — varchar(255) — Primary key — NOT NULL
- ip — varchar(255) — Primary key — NOT NULL
- created_date — timestamp
- modified_date — timestamp
- context — varchar(300)
summoner
- account_id — varchar(60) — NOT NULL
- created_date — timestamp
- modified_date — timestamp
- id — varchar(255)
- name — varchar(20)
- profile_icon_id — integer
- puuid — varchar(80)
- revision_date — bigint
- search_name — varchar(20)
- summoner_level — integer
system
- property_name — varchar(30) — NOT NULL
- created_date — timestamp
- modified_date — timestamp
- property_value1 — varchar(500)
- property_value2 — varchar(500)
user_alarm
- alarm_seq — bigint — NOT NULL
- created_date — timestamp
- modified_date — timestamp
- alarm_type — varchar(255)
- is_delete — boolean
- is_read — boolean
- landing_url — varchar(255)
- message — varchar(255)
- user_seq — bigint
web_user
- user_seq — bigint — NOT NULL — 유저순번
- created_date — timestamp
- modified_date — timestamp
- authority — varchar(255)
- password — varchar(255)
- user_id — varchar(255)
- confirm — boolean
- email — varchar(255)
- refresh_token — varchar(200)