pinpal

Tables (9)

bowling_center

  • bowling_center_id — bigint — Primary key — NOT NULL
  • name (Field) — varchar(30)
  • address — varchar(50)
  • description — text

ceremony

  • ceremony_id — bigint(20) — Primary key — NOT NULL
  • avg_1st — bigint(20)
  • grade1_1st — bigint(20)
  • grade2_1st — bigint(20)
  • grade3_1st — bigint(20)
  • grade4_1st — bigint(20)
  • high_score_girl — bigint(20)
  • high_score_man — bigint(20)
  • total_1st — bigint(20)
  • club_id — bigint(20) — Foreign key → club_mst.club_id
  • game_id — bigint(20) — Foreign key → game.game_id

ceremony_team_1st

  • ceremony_id — bigint(20) — Foreign key → ceremony.ceremony_id — NOT NULL
  • team_1st_id — bigint(20)

club_dtl

  • no — bigint(20) — Primary key — NOT NULL
  • avg — int(11)
  • create_date — datetime(6)
  • grade — int(11)
  • role — varchar(255)
  • update_date — datetime(6)
  • club_id — bigint(20) — Foreign key → club_mst.club_id
  • member_id — bigint(20) — Foreign key → member.member_id

club_mst

  • club_id — bigint(20) — Primary key — NOT NULL
  • create_date — datetime(6)
  • description — text
  • name — varchar(255)
  • update_date — datetime(6)
  • bowling_center_id — bigint — Foreign key → bowling_center.bowling_center_id — NOT NULL

game

  • game_id — bigint(20) — Primary key — NOT NULL
  • confirmed_code — varchar(255)
  • create_date — datetime(6)
  • date — date
  • name — varchar(255)
  • score_counting — bit(1)
  • status — varchar(255)
  • time — time
  • type — varchar(255)
  • update_date — datetime(6)
  • club_id — bigint(20) — Foreign key → club_mst.club_id
  • deleted — int(11)
  • bowling_center_id — bigint — Foreign key → bowling_center.bowling_center_id — NOT NULL

member

  • member_id — bigint(20) — Primary key — NOT NULL
  • birth — varchar(255)
  • create_date — datetime(6)
  • email — varchar(255)
  • gender — int(11) — NOT NULL
  • join_path — varchar(255)
  • name — varchar(255)
  • password — varchar(255)
  • profile — varchar(255)
  • roles — varchar(255)
  • sns_id — varchar(255)
  • status — varchar(255)
  • update_date — datetime(6)

member_dtl

  • member_id — bigint(20) — Foreign key → member.member_id — NOT NULL
  • phone — varchar(255)

scoreboard

  • scoreboard_id — bigint(20) — Primary key — NOT NULL
  • all_cover — int(11) — NOT NULL
  • confirmed_join — bit(1)
  • create_date — datetime(6)
  • game_1 — int(11)
  • game_2 — int(11)
  • game_3 — int(11)
  • game_4 — int(11)
  • grade — int(11)
  • member_avg — int(11)
  • member_profile — varchar(255)
  • side_avg — bit(1)
  • side_grade1 — bit(1)
  • status — varchar(255)
  • team_number — int(11)
  • update_date — datetime(6)
  • game_id — bigint(20) — Foreign key → game.game_id
  • member_id — bigint(20) — Foreign key → member.member_id