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)