길드_모델링

테이블 (9)

bingo_slot_data (Untitled)

  • binggo_id (Key) — 기본 키 — NOT NULL
  • slot_number (Field8)
  • slot_grade (Field)
  • condition_lv (Field2)
  • condition_star (Field3)
  • condition_sub_star (Field4)
  • condition_evolve (Field5)
  • condition_skill_A (Field6)
  • condition_research_lv (Field7)

guild

  • guild_base_id (Key) — int(11) — 기본 키 — NOT NULL
  • guild_vice_master_cnt (Field) — int(11)
  • item_req_cnt (Field2) — int(11)
  • today_item_req_cnt (Field3) — int(11)
  • binggo_req_cnt (Field4) — int(11)
  • today_binggo_req_cnt (Field5) — int(11)
  • send_cnt (Field6) — INT(11)
  • today_send_cnt (Field7) — INT(11)

guild_lv

  • lv (Key) — int — 기본 키 — NOT NULL
  • need_exp (Field2) — int(11)

user_binggo

  • id (Key) — bigint — 기본 키 — NOT NULL
  • user_id (Field) — varchar(10)
  • slot_1 (Field2) — int(11)
  • slot_2 (Field3) — int(11)
  • slot_3 (Field4) — int(11)
  • slot_4 (Field5) — int(11)
  • slot_5 (Field6) — int(11)
  • slot_6 (Field7) — int(11)
  • slot_7 (Field9) — int(11)
  • slot_8 (Field8) — int(11)
  • slot_9 (Field10) — int(11)
  • binggo_id (Key2) — 외래 키 → bingo_slot_data.binggo_id — NOT NULL

user_guild

  • guild_id (Key3) — bigint — 기본 키 — NOT NULL
  • guild_name (name) — varchar(8)
  • introduce_text — varchar(200)
  • emblem_idx — int(11)
  • join_type — int(11)
  • join_point — int(11)
  • exp — int(11)
  • create_date — datetime
  • people_cnt — int(11)
  • master_id — varchar(10)
  • lv (Key) — int(11) — 외래 키 → guild_lv.lv — NOT NULL
  • guild_base_id (Key2) — int(11) — 외래 키 → guild.guild_base_id — NOT NULL

user_guild_join

  • id (Key) — bigint — 기본 키 — NOT NULL
  • user_id (Key2) — varchar(10) — 기본 키 — NOT NULL
  • nickname (Field2) — VARCHAR(20)
  • call_time (Field3) — datetime
  • guild_id (Key3) — bigint — 외래 키 → user_guild.guild_id — NOT NULL

user_guild_leave

  • id (Key) — bigint — 기본 키 — NOT NULL
  • user_id (Key2) — varchar(10) — 기본 키 — NOT NULL
  • guild_name (Field) — char(8)
  • guild_posion (Field3) — int(11)
  • leave_time (Field4) — datetime
  • join_time (Field5) — datetime
  • last_login_time (Field6) — datetime
  • guild_id (Key3) — bigint — 외래 키 → user_guild.guild_id — NOT NULL

user_guild_message

  • id (Key) — bigint — 기본 키 — NOT NULL
  • user_id (Key2) — varchar(10) — 기본 키 — NOT NULL
  • type (Field) — char(1)
  • write_time (Field2) — datetime
  • remain_time (Field3) — datetime
  • text (Field4) — text
  • item_id (Field5) — int(11)
  • item_req_cnt (Field6) — int(11)
  • item_send_cnt (Field7) — int(11)
  • reward_exp (Field9) — int(11)
  • reward_gold (Field10) — int(11)
  • reward_item_id (Field11) — int(11)
  • reward_item_cnt (Field12) — int(11)
  • guild_id (Key32) — bigint — 외래 키 → user_guild.guild_id — NOT NULL
  • binggo_id (Key3) — 외래 키 → bingo_slot_data.binggo_id — NOT NULL

user_guild_people

  • id (Key) — bigint — 기본 키 — NOT NULL
  • user_id (Key2) — varchar(10) — 기본 키 — NOT NULL
  • guild_position (Field2) — char(1)
  • guild_attendance (Field) — int(11)
  • attendance_degree (Field3) — int(11)
  • join_time (Field4) — datetime
  • last_login_time (Field5) — datetime
  • today_item_req_cnt (Field7) — int(11)
  • today_binggo_req_cnt (Field6) — int(11)
  • today_send_cnt (Field9) — int(11)
  • guild_id (Key32) — bigint — 외래 키 → user_guild.guild_id — NOT NULL