guild

Tables (6)

EVENT (Untitled4)

  • eventId (Key) — Primary key — NOT NULL
  • created_at (Field)
  • modified_at (Field2)
  • status (Field3)
  • guild_id (Key2) — Foreign key → GUILD.guild_id — NOT NULL

GAME (Untitled6)

  • game_id (Key) — Primary key — NOT NULL
  • name (Field)
  • status (Field2)

GUILD (Untitled2)

  • guild_id (Key) — Primary key — NOT NULL
  • status (Field2)
  • game_id (Key2) — Foreign key → GAME.game_id — NOT NULL

MEMBER (Untitled)

  • member_Id — Primary key — NOT NULL
  • name
  • email
  • password
  • phone
  • role
  • status

MEMBER_EVENT (Untitled5)

  • member_event_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → MEMBER.member_Id — NOT NULL
  • eventId (Key3) — Foreign key → EVENT.eventId — NOT NULL

MEMBER_GUILD (Untitled3)

  • member_guild_id (Key) — Primary key — NOT NULL
  • created_at (Field2)
  • modified_at (Field3)
  • status (Field4)
  • role (Field5)
  • game_id (Field)
  • member_id (Key2) — Foreign key → MEMBER.member_Id — NOT NULL
  • guild_id (Key3) — Foreign key → GUILD.guild_id — NOT NULL