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