moai

Tables (8)

calander_share_users (Untitled5)

  • calander_id (Key2) — int8 — Foreign key → calanders.user_id — NOT NULL
  • user_id (Key) — varchar(50) — Foreign key → users.user_id — NOT NULL

calanders (Untitled2)

  • calander_id (Key) — int8 — Primary key — NOT NULL
  • user_id (Key2) — varchar(50) — Foreign key → users.user_id — NOT NULL
  • start_date (Field) — datetime — NOT NULL
  • end_date (Field2) — datetime
  • title (Field3) — varchar(255) — NOT NULL

chat_logs (Untitled3)

  • chat_id (Key) — int8 — Primary key — NOT NULL
  • user_id (Key2) — varchar(50) — Foreign key → users.user_id — NOT NULL
  • room_id (Key3) — int8 — Foreign key → rooms.room_id — NOT NULL
  • chat_at (Field) — timestamp
  • chat (Field4) — varchar

group_join_users (Untitled9)

  • user_id (Key) — varchar(50) — Foreign key → users.user_id — NOT NULL
  • group_id (Key2) — int8 — Foreign key → groups.group_id — NOT NULL

groups (Untitled8)

  • group_id (Key) — int8 — Primary key — NOT NULL
  • group_name (Field) — varchar

room_users (Untitled7)

  • user_id (Key) — varchar(50) — Foreign key → users.user_id — NOT NULL
  • room_id (Key2) — int8 — Foreign key → rooms.room_id — NOT NULL

rooms (Untitled4)

  • room_id (Key) — int8 — Primary key — NOT NULL
  • create_at (Field) — timestamp

users (Untitled)

  • user_id (Key) — varchar(50) — Primary key — NOT NULL
  • name (Field2) — varchar(50) — NOT NULL
  • job_id (Field3) — varchar(50) — NOT NULL
  • user_pw (Field) — varchar(50) — NOT NULL